anand
anand
Reputation Top 5%
Pallav Anand
3 Snippets  (189th place)
Published
1 Channel
Created
5 Channels
Following
78 points  (339th place)
Reputation
Junior Code Generator
Serious Code Generator
Senior Code Generator
Junior Popular Coder
Junior Autobiographer
Senior Autobiographer

Recent Snippets See all snippets by anand

public by anand  248  0  3  0

test1

test1: test1
test1

;

public by anand  183  0  2  0

change ownership for a file

change ownership for a file: new_gist_file_0
chown pallanan file1.txt

chown :amazon file1.txt   #this will the user group

chown pallanan:amazon file1.txt 

;

public by anand  261  0  3  0

LENGTH OF CHARACTER, ORDER BY AND LIMIT

LENGTH OF CHARACTER, ORDER BY AND LIMIT: new_gist_file.sql
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

;