Top "Sql-order-by" questions

Is MySQL LIMIT applied before or after ORDER BY?

Which one comes first when MySQL processes the query? An example: SELECT pageRegions FROM pageRegions WHERE(pageID=?) AND(published=true) …

sql mysql sql-order-by limit

Orderby() not ordering numbers correctly c#

I am writing an app for my company and am currently working on the search functionality. When a user searches …

c# asp.net-mvc linq linq-to-sql sql-order-by

SQL: Using Top 1 in UNION query with Order By

I have a table as below Rate Effective_Date ---- -------------- 5.6 02/02/2009 5.8 05/01/2009 5.4 06/01/2009 5.8 12/01/2009 6.0 03/15/2009 I am supposed to find the all rates that …

sql-server sql-order-by union

MySQL order by "best match"

I have a table that contains words and an input field to search that table using a live search. Currently, …

mysql sql sql-order-by

How to change the collation of sqlite3 database to sort case insensitively?

I have a query for sqlite3 database which provides the sorted data. The data are sorted on the basis of …

sql sqlite sql-order-by case-insensitive

SQL Server UNION - What is the default ORDER BY Behaviour

If I have a few UNION Statements as a contrived example: SELECT * FROM xxx WHERE z = 1 UNION SELECT * FROM xxx …

sql sql-server union sql-order-by

JPQL ORDER BY clause with parameter

I'm trying to write a JPQL Query with an ORDER BY clause: query = "SELECT c FROM item ORDER BY c.…

hibernate orm jpa sql-order-by jpql

When no 'Order by' is specified, what order does a query choose for your record set?

I was always of the impression that a query with no specified 'Order by' rule, would order this by the …

sql sql-server tsql sql-order-by

Custom sort logic in OrderBy using LINQ

What would be the right way to sort a list of strings where I want items starting with an underscore …

c# .net linq sorting sql-order-by

Best way to save a ordered List to the Database while keeping the ordering

I was wondering if anyone has a good solution to a problem I've encountered numerous times during the last years. …

c# database nhibernate sql-order-by