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
what is a view? : Sql dba
Which is better join or inner query?
what happens if you no create privilege in a database? : Sql dba
What is the life of an sql statement?
Why procedure is used in sql?
Write the alter statement to enable all the triggers on the t.students table.
How to run sql*plus commands in sql developer?
When you have to use a default "rollback to" savepoint of plvlog?
What is native sql query?
What are the properties of a transaction?
What are sql queries used for?
What is difference between stored function and application function?
Why partition by is used in sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is pragma in pl sql?