Tag: sql

Oracle – Coordinate extraction from vertices (first, last and all vertices)

For a given feature (line or area) and for all of its members I need to extract the coordinates of (1) all the vertices, (2) the first vertex and (3) the last vertex (3 separate queries to create 3 …

Ordering records by an association presence

activerecord postgresql ruby-on-rails ruby-on-rails-5 sql

Lets say I have an instructions table which is associated to a surveys table through survey_instructions join table. What I need to achieve is to fetch all instruction records, but ordered by an …

Find How many minutes a month has: MySQL

date mysql sql

Say I have a column Date 23-03-2019 04-04-2019 I want to find hoe many minutes the whole month has in MySQL. Expected output: Date MinsinMonth 23-03-2019 44640 04-04-2019 …

Count the number of records in SQL results before a certain value is reached

clause count record sql vbscript

Looking to count the number of SQL records until a certain value in one of the table columns is reached. Using Asp /VBscript. Not sure how to formulate the query. What I’ve tried is but of course it …

Select first 10 rows of a column in a table

sql sql-server

Can you please let me know how to select first 10 rows for every cusip in the below table SELECT [dt_dim_id], [cusip_num], sr.[product_dim_id], [acct_dim_id], […

SQL many to many

join many-to-many mysql sql

I have fivetables here: User +——–+———-+ | stu_id | batch-id | +——–+———-+ | 1 | 1 | | 2 | 1 | | 3 | 1 | +——–+———-+ subject_id +-…

Unterminated dollar quote

postgresql sql

How to use IF statement in the PostgreSql (11 version)? I tried just raw IF usage but got problem (syntax error at or near “IF”). To resolve this problem people propose to use ‘do &&’ but it does not work as well (Unterminated dollar quote started at position 3 in SQL DO $$ BEGIN IF &#8230…