software world tip all about given knowledge and tip share for software language, software programming with various topic in it
Saturday, 2 February 2019
Wednesday, 23 January 2019
The ORDER BY Clause
This clause lets results be displayed in ascending or descending order. Keywords:
ASC - Ascending order.
DESC - Descending order.
Other Keywords
ALL - Used to select all records.
DISTINCT - Used to select unique records. Only unique values are returned.
Example:- SELECT city, state FROM towntable WHERE population > '100000';
ASC - Ascending order.
DESC - Descending order.
Other Keywords
ALL - Used to select all records.
DISTINCT - Used to select unique records. Only unique values are returned.
Example:- SELECT city, state FROM towntable WHERE population > '100000';
Subscribe to:
Posts (Atom)