how to reverse a sequence

Question

my table

EMP_NO                 EMP_NAME   
---------------------- ---------- 
1                      ram        
2                      mohan      
3                      raju       
4                      santosh    
5                      nikil      
6                      praveen    
7                      manju      
8                      hari       
9                      kumar      
10                     hareesh    
11                     chndra     

i created sequence on the emp_no(that sequence name is sequence_1).now i want query for sequence is started with max value(11) in above and decrease the sequence upto (1)

my expected result is

EMP_NO                 EMP_NAME   
---------------------- ---------- 
11                      ram        
10                     mohan      
9                     raju       
8                      santosh    
7                      nikil      
6                      praveen    
5                      manju      
4                      hari       
3                      kumar      
2                     hareesh    
1                     chndra     

for this purpose give me query please.thanks in advance

Answer 1

For Sql Sever

Select Row_Number() Over(Order By [EMP_NO] Desc) as Emp_No,
       EMP_NAME  
       from TableName
       Order By [Emp_No] Desc

Sql Fiddle Demo

For Oracle Sql Developer

Select Row_Number() Over(Order By "EMP_NO" Desc) as "Emp_No",
       "EMP_NAME"  
       from Table1
       Order By "Emp_No" Desc

Sql Fiddle Demo