Top "Sql-order-by" questions

group_concat in SQL Server 2012 with ORDER BY another column

I have a table containing ~ a million entries like this: customer_id | purchased_at | product 1 | 2012-06-01 00:00 | apples 1 | 2012-09-02 00:00 | …

sql-order-by sql-server-2012 sql-server-group-concat

inner join and union all using order by

I have this query: SELECT B.IMAGE_ID as image_id_fav,I.Image_Path as image_path_fav FROM …

sql sql-server join sql-order-by union-all

Symfony2 createQuery order by field

Hi i have this query writen in phpmyadmin and it works gr8. SELECT u.* FROM users AS u WHERE u.…

symfony doctrine-orm sql-order-by field createquery

how does ordering by UUID work in PostgreSQL?

Is there any ordering guarantee on using uuid_generate_v1() on postgresql? If yes,tThe guarantees are per machine or …

postgresql sql-order-by uuid postgresql-9.4

Custom SQL sort by

Use: The user searches for a partial postcode such as 'RG20' which should then be displayed in a specific …

sql postgresql sql-order-by postal-code

ORDER BY upper(...) with a UNION giving me problems

I'm having a bit of trouble figuring out why I'm having this problem. This code works exactly how it should. …

sql oracle sql-order-by oracle-sqldeveloper union-all

Alphanumeric Order By in Mysql

How can i make only numeric order by when the column containing alphanumeric characters in mysql ? column (name) is unique …

mysql sql-order-by alphanumeric

Mysql - return last 3 results in table

i was wondering if there was an easy way with just an sql statement to return the last three results …

mysql sql-order-by sql-limit