04pallav
9/13/2017 - 9:54 PM

LENGTH OF CHARACTER, ORDER BY AND LIMIT

LENGTH OF CHARACTER, ORDER BY AND LIMIT

SELECT CITY,LENGTH(CITY) FROM STATION ORDER BY CITY ASC LIMIT 1;


SELECT * FROM CUSTOMERS
   ORDER BY (CASE ADDRESS
   WHEN 'DELHI' 	 THEN 1
   WHEN 'BHOPAL' 	 THEN 2
   WHEN 'KOTA' 	 THEN 3
   WHEN 'AHMADABAD' THEN 4
   WHEN 'MP' 	THEN 5
   ELSE 100 END) ASC, ADDRESS DESC;     ###ORDERING IN A PARTICULAR ORDER
   
   
select * from nobel where winner like 'Sir%' order by yr desc,winner asc