anand
anand
Reputation Top 5%
Pallav Anand
3 Snippets  (191st place)
Published
1 Channel
Created
5 Channels
Following
78 points  (340th 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  265  0  3  0

test1

test1: test1
test1

;

public by anand  204  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  293  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

;