: ORDER BY : Select Query MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Select Query
»
ORDER BY
»
14.1 .
Using both DESC and ASC in order clause
Hits: 1510
14.2 .
To use a case-sensitive sort for a column by using BINARY
Hits: 1363
14.3 .
On character type columns, sorting is normally performed in a case-insensitive fashion
Hits: 1335
14.4 .
You can retrieve rows in random order
Hits: 1292
14.5 .
Order first 4 rows
Hits: 1254
14.6 .
Order by with 'limit' clause
Hits: 1262
14.7 .
Sort by date
Hits: 1619
14.8 .
We can use two or more ORDER BY conditions
Hits: 1240
14.9 .
DESC keyword applies only to the column name immediately preceding it
Hits: 1254
14.10 .
To sort in reverse (descending) order, add the DESC keyword to the name of the column
Hits: 1259
14.11 .
Sort the results in reverse by appending DESC to the condition
Hits: 1259
14.12 .
ORDER BY controls the sequence of results
Hits: 1281
MySQL TUTORIALS
Select Query
»
ORDER BY
Introduction
DISTINCT
WHERE
EXISTS
GROUP BY
NOT EXISTS
ORDER BY
IN
HAVING
IS NULL
LIMIT
Like
Column
Logic Operators
Alias
Row Constructor
AND OR
UNION
NOT
User Defined Variables
AS
Full Text Search
BETWEEN
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
Using both DESC and ASC in order clause
