Write a query to find second highest salary of an employee.
Answer Posted / akilis.org@hotmail.com
Let us assume that
Table Name:salary
Coloumn Name:maxsal(int)
select * from salary order by maxsal desc limit 1,1;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What information is needed to connect sql*plus an oracle server?
Is sql a dbms?
Is sql a programming?
What are the 3 modes of parameter?
Does asenumerable execute the query?
What is a unique constraint?
Can you do multiple joins in sql?
What is db journal file?
Which query operators in sql is used for pattern matching?
What is over () in sql?
How is data stored in sql?
Could you please provide oca (oracle 10g) dumps for my certification ?
what are all different types of collation sensitivity? : Sql dba
What sql does db2 use?
What is the syntax to add a record to a table?