Tag: order-by


Found 151 results for 'order-by'.


1) postgresql - Order of returned rows with IN statement
2) postgresql - Postgresql: sort by value position in array column, then by secondary order
3) postgresql - How to remove duplicates from any array and preserve ordering in PostgreSQL?
4) mysql - Extract data for all groups in a single SELECT statement
5) postgresql - Why is this query with WHERE, ORDER BY and LIMIT so slow?
6) sql-server - Parent-Child Tree Hierarchical ORDER
7) postgresql - How to get 0 as array_length() result when there are no elements
8) postgresql - How do I sort the results of a recursive query in an expanded tree-like fashion?
9) postgresql - How to apply ORDER BY and LIMIT in combination with an aggregate function?
10) postgresql - SQL order by query results in any arbitrary (but reproducible) manner
11) postgresql - In PostgreSQL is the row ordering preserved in functions and CTEs?
12) sql-server - Distinct Children rows ordered by a column of Parent
13) sql-server - Are the results of the STRING_SPLIT() function returned in a deterministic order?
14) order-by - Database Implementations of ORDER BY in a Subquery
15) mysql - Is it REALLY possible that the order will not be guaranteed for this particular redundant derived table?
16) postgresql - Filter on array text[] and sort on timestamp
17) postgresql - ORDER BY clause kills query performance
18) mysql - MySQL: Why queries with subqueries are much faster than single query?
19) postgresql - Clever way to order a json item by key in postgresql (two examples)
20) mysql - Optimizing ORDER BY for simple MySQL query
21) postgresql - Optimize a trigram search with custom sort order
22) postgresql - case sensivity incongruity
23) postgresql - Is there any way in Postgres to parameterise a procedure for sort order column, when the columns are of different types?
24) mysql - Filesort while using primary key for orderby
25) mysql - MySQL: Optimize UNION with "ORDER BY" in inner queries
26) mysql - MySql: #1221 - Incorrect usage of UNION and ORDER BY
27) postgresql - How to optimize multiple ORDER BYs?
28) sql-server - SELECT Parent-Child with SORT
29) postgresql - Does Postgres preserve insertion order of records?
30) postgresql - CTE clause not able to be used in final ORDER BY statement
31) mysql - increment row value does not work properly with where condition
32) mysql - Sort table by column with column ordered by earliest instance of another column
33) postgresql - Operator "~<~" uses varchar_pattern_ops index while normal ORDER BY clause doesn't?
34) oracle - Oracle - WHY do an ORDER BY for INSERTs AS SELECT?
35) postgresql - SELECT DISTINCT ON, ordered by another column
36) mysql - Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
37) mysql - MySQL Grouping Order
38) mysql - How to cast (a) a date value recorded as a VARCHAR to (b) a specific DATE format for (c) use in an ORDER BY clause
39) sql-server - Determine Order Streak
40) postgresql - Ordering in postgresql
41) oracle - oracle sql: How to not select select duplicate records from table
42) mysql - How to cache select with variables? (MySQL)
43) postgresql - Unused index in range of dates query
44) mysql - column_name ordered same as describe table
45) postgresql - Postgres slow query with order by, index and limit
46) mysql - ORDER BY indexedColumn ridiculously slow when used with LIMIT on MySQL
47) mysql - Using an index for both asc and desc on a string column
48) postgresql - ORDER BY gives ERROR: function array_position(text[], character varying) does not exist
49) mysql - Order large numbers that are saved as a varchar
50) postgresql - The opposite of ordering by a column in SQL