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:


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