Interested to Buy Any Domain ? << Click Here >> for more details...
Given an employee table, how would you find out the second
highest salary?
- 9 Answers
- 14203 Views
- I also Faced
- E-Mail Answers
Answer Posted / balindra sahani
select max(sal) from emp
where sal not in (select max(sal) from emp order by sal desc )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain about network model?
How to combine two function together?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain the cube operator?
How to use timestamp datatypes
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How long can an error message be in raiseerror function?
What are the three basic rules which are to be followed for the relational model of the database?
What is dbms explain in brief?
What is the maximum length of an extended property?
What is DB Development software?
In which table collections errors are stored.
How to read and create .LDC data files which are used by linguatic dictionary.
Write the fastest query to find out how many rows exist in a table?
