by
0
3
261
0
Top 10% !
Popular
Specified

Published on:

No tags for this snippet yet.
LanguageSQL
SourceGitHub
SourceMyGists

LENGTH OF CHARACTER, ORDER BY AND LIMIT

LENGTH OF CHARACTER, ORDER BY AND LIMIT: 
new_gist_file.sql
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/3011296/LENGTH-OF-CHARACTER--ORDER-BY-AND-LIMIT?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
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
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus