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
Why having clause is used in sql?
What is t sql used for?
What is the sql query to display the current date?
What is the difference between partition and index?
Compare sql & pl/sql
What is acid property in a database?
what are the different type of sql's statements ? : Sql dba
How do you declare a variable in pl sql?
What is the difference between delete, truncate and drop command?
Is left join and outer join same?
What is sql comments?
what is bcp? When does it used? : Sql dba
Explain the rollback statement?
What are the types of index in sql?
When do we use triggers?