how to calcuate the second highest salary of he employee

Answer Posted / sunilpanghal

select rownum as rowid,salary from (salary from employees
oderby salary )where rownum <2

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql microsoft?

537


Does view contain data?

608


What are stored procedures used for?

528


What is trigger in pl sql?

550


what is index? : Sql dba

552






What is sql clause?

535


What are the possible values for the boolean data field?

509


When is the explicit cursor used ?

582


What is sql and how does it work?

538


Is left join faster than join?

532


What is a temporal data type?

587


write an sql query to find names of employee start with 'a'? : Sql dba

571


What is sql performance tuning?

486


what is the difference between $message and $$message? : Sql dba

540


Can you join views in sql?

529