Practice Center – Select with Order By

Exercise 1

Show all records from the table clients, starting with the highest client_id on the first row, and lowest client_id on last row.


Exercise 2

Show all records from the table clients, starting with the lowest client_id on the first row, and highest client_id on last row.


Exercise 3

Display the following from the table clients:

statelast_name
DelhiRao
KarnatakaVerma
KarnatakaGupta
KeralaLuciani
MaharashtraRao
MaharashtraRao
MaharashtraKapoor
Uttar PradeshRangan
Uttar PradeshMalhotra



Exercise 4

Display the following from the table clients:

statelast_name
DelhiRao
KarnatakaGupta
KarnatakaVerma
KeralaLuciani
MaharashtraKapoor
MaharashtraRao
MaharashtraRao
Uttar PradeshMalhotra
Uttar PradeshRangan



 
Share on:

Something not clear? Ask your question here:

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

 
 

One question on “Practice Center – Select with Order By


Author:
Last udpated: June 8, 2016
Created: January 1, 2015