Top "Sql-order-by" questions

ORDER BY date and time BEFORE GROUP BY name in mysql

i have a table like this: name date time tom | 2011-07-04 | 01:09:52 tom | 2011-07-04 | 01:09:52 mad | 2011-07-04 | 02:10:53 mad | 2009-06…

mysql sorting group-by sql-order-by

C# Sort and OrderBy comparison

I can sort a list using Sort or OrderBy. Which one is faster? Are both working on same algorithm? List&…

c# .net performance sorting sql-order-by

Sort CSV file by column priority using the "sort" command

I have a csv file, and I would like to sort it by column priority, like "order by". For example: 3;1;2 1;3;2 1;2;3 2;3;1 2;1;3 3;2;1 …

unix sorting csv sql-order-by

How to use SQL Order By statement to sort results case insensitive?

I have a SQLite database that I am trying to sort by Alphabetical order. The problem is, SQLite doesn't seem …

sql sqlite sorting sql-order-by

Order by multiple columns with Doctrine

I need to order data by two columns (when the rows have different values for column number 1, order by it; …

php doctrine sql-order-by

How to update and order by using ms sql

Ideally I want to do this: UPDATE TOP (10) messages SET status=10 WHERE status=0 ORDER BY priority DESC; In English: I …

sql sql-server tsql sql-order-by sql-update

Combining ORDER BY AND UNION in SQL Server

How can I get first record of a table and last record of a table in one result-set? This Query …

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

MySQL: Alternatives to ORDER BY RAND()

I've read about a few alternatives to MySQL's ORDER BY RAND() function, but most of the alternatives apply only to …

sql mysql random sql-order-by

MySQL: Sort GROUP_CONCAT values

In short: Is there any way to sort the values in a GROUP_CONCAT statement? Query: GROUP_CONCAT((SELECT GROUP_…

mysql sorting sql-order-by group-concat

Preserving ORDER BY in SELECT INTO

I have a T-SQL query that takes data from one table and copies it into a new table but only …

sql-server tsql sql-order-by select-into