Questions tagged [sql-order-by]

66

votes

5

answers

ORDER BY "ENUM field" in MYSQL

asked 2013-07-11T21:32:08.793

298

votes

13

answers

Laravel Eloquent: Ordering results of all()

laravel laravel-4 eloquent sql-order-by

asked 2013-07-02T15:18:42.797

10

votes

2

answers

How to write a query with join, update and order by?

mysql sql join sql-update sql-order-by

asked 2013-05-08T15:27:55.197

14

votes

2

answers

Is SQL order by clause guaranteed to be stable ( by Standards)

sql database sql-order-by

asked 2013-03-20T11:51:56.193

10

votes

1

answers

MySQL: Grouped/Ordered/Left Join query very slow

mysql group-by sql-order-by left-join

asked 2013-03-07T13:46:45.543

18

votes

1

answers

MySQL order by (str to int)

mysql sql-order-by

asked 2013-02-05T13:48:58.573

48

votes

11

answers

Preserving ORDER BY in SELECT INTO

sql-server t-sql sql-order-by select-into

asked 2013-01-20T13:18:00.223

11

votes

5

answers

Prevent SQL Injection in ORDER BY clause

c# sql-server-2008 sql-order-by sql-injection

asked 2013-01-14T11:10:02.063

14

votes

4

answers

Order by datetime mysql

mysql datetime sql-order-by

asked 2012-12-16T08:32:04.773

9

votes

2

answers

Select query using IN() and without any sorting

mysql sql sorting sql-order-by

asked 2012-12-01T08:45:33.200

15

votes

7

answers

MySQL order by string with numbers

mysql sql-order-by collation

asked 2012-08-23T17:50:12.397

9

votes

1

answers

Is it possible to use bind_param for ORDER BY?

php mysqli sql-order-by prepared-statement bindparam

asked 2012-08-18T18:07:21.650

8

votes

1

answers

Strange ordering bug (is it a bug?) when ordering two columns with identical values

sql postgresql sql-order-by limit offset

asked 2012-08-10T15:26:36.710

206

votes

10

answers

SQL order string as number

sql mysql sql-order-by

asked 2012-08-04T12:12:58.657

11

votes

6

answers

In Django, how can I order by a multiple-choice CharField in arbitrary not alphabetical order?

django django-models sql-order-by

asked 2012-07-27T21:38:10.107

12

votes

2

answers

Multiple columns in OVER ORDER BY

sql sql-server sql-order-by row-number

asked 2012-07-27T15:33:30.833

17

votes

4

answers

MYSQL - Order timestamp values ascending in order, from newest to oldest?

mysql timestamp sql-order-by

asked 2012-07-15T16:09:54.927

25

votes

2

answers

Table-Valued function - Order by is ignored in output

sql sql-server sql-server-2012 sql-order-by

asked 2012-06-27T08:18:10.703

58

votes

1

answers

What does "ORDER BY (SELECT NULL)" mean?

sql-server select sql-order-by

asked 2012-04-08T21:45:45.163

8

votes

5

answers

ORDER BY varchar with [a-9] instead of [0-Z] in SQL

sql sqlite sql-order-by

asked 2012-03-26T13:32:12.367

19

votes

4

answers

Order by field in cakephp

php cakephp sql-order-by

asked 2012-03-23T09:26:29.570

359

votes

7

answers

PostgreSQL DISTINCT ON with different ORDER BY

sql postgresql sql-order-by distinct-on

asked 2012-03-20T21:59:36.757

10

votes

2

answers

Linq orderyby boolean

c# linq sql-order-by

asked 2012-02-28T11:28:04.337

13

votes

4

answers

MYSQL Select from table, get newest/last 10 rows in table

sql mysql sql-order-by

asked 2012-02-24T01:58:53.900

98

votes

4

answers

mysql order by, null first, and DESC after

mysql sql-order-by

asked 2012-02-16T08:08:17.443

29

votes

4

answers

Order by column should have index or not?

mysql sql performance indexing sql-order-by

asked 2012-01-20T07:26:06.127

14

votes

3

answers

ORDER BY with columns that are sometimes empty

sql sql-order-by coalesce

asked 2011-11-14T11:33:43.183

16

votes

6

answers

PHP and MySQL: Order by most recent date and limit 10

php mysql sql-order-by limit querying

asked 2011-08-27T14:03:39.923

75

votes

7

answers

Incorrect usage of UNION and ORDER BY?

mysql sql-order-by union

asked 2011-07-18T12:10:00.823

28

votes

6

answers

How does mysql order rows with the same value?

mysql sql-order-by

asked 2011-07-12T10:35:20.803

10

votes

1

answers

NHIbernate (3.1) - Linq group by then order by count issue

linq nhibernate fluent-nhibernate group-by sql-order-by

asked 2011-05-17T10:40:50.657

173

votes

14

answers

How to use DISTINCT and ORDER BY in same SELECT statement?

sql sql-order-by distinct

asked 2011-03-22T12:55:01.800

54

votes

10

answers

MySQL Order before Group by

mysql wordpress group-by sql-order-by

asked 2011-02-28T10:28:35.300

16

votes

5

answers

ORDER By Unix Timestamp DESC or ASC?

sql mysql sql-order-by unix-timestamp

asked 2011-02-16T19:39:22.837

16

votes

1

answers

MySQL SELECT CASE WHEN something THEN returning null

mysql select sql-order-by case

asked 2011-01-11T15:14:47.243

187

votes

7

answers

C# list.Orderby descending

c# list sorting sql-order-by

asked 2010-10-13T15:21:57.140

21

votes

4

answers

JPQL ORDER BY clause with parameter

hibernate orm jpa sql-order-by jpql

asked 2010-09-01T08:30:05.287

14

votes

3

answers

How to optimize an ORDER BY for a computed column on a MASSIVE MySQL table

mysql query-optimization sql-order-by

asked 2010-08-03T18:36:19.393

13

votes

3

answers

Best practice question for MySQL: order by id or date?

mysql sql-order-by

asked 2010-01-30T03:53:45.233

10

votes

10

answers

Why or why not do an ORDER BY in a subquery?

sql subquery sql-order-by

asked 2010-01-20T14:15:06.543

359

votes

14

answers

MySQL Orderby a number, Nulls last

mysql sql-order-by

asked 2010-01-12T19:09:39.710

966

votes

9

answers

SQL multiple column ordering

sql sorting sql-order-by multiple-columns

asked 2010-01-12T18:02:09.567

23

votes

6

answers

What is MySQL row order for "SELECT * FROM table_name;"?

mysql select sql-order-by

asked 2009-12-22T22:32:13.623

13

votes

4

answers

How can I sort by the id of a ManyToManyField in Django?

python django django-models sql-order-by manytomanyfield

asked 2009-12-15T03:25:11.790

16

votes

6

answers

SQL ORDER by `no` with NULLs at the end

mysql sql-order-by

asked 2009-12-10T11:08:24.590

49

votes

6

answers

How to order 1,2,3 instead of 1, 10, 11, 12 in MySQL when the column to sort by is a string?

mysql sql-order-by

asked 2009-12-02T14:03:00.083

10

votes

5

answers

How can I reverse the default ordering in MySQL?

sql mysql sorting sql-order-by

asked 2009-11-27T06:22:17.917

44

votes

10

answers

SQL best practice to deal with default sort order

sql database sql-order-by

asked 2009-11-24T21:47:26.243

76

votes

5

answers

ORDER BY using Criteria API

java hibernate sql-order-by hql

asked 2009-11-22T21:55:13.283

57

votes

12

answers

SQL ORDER BY date problem

sql date sql-order-by

asked 2009-10-09T20:27:06.967

Questions tagged sql-order-by