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
- 14822 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 )
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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?
Where is dbms used?
What are the three types of database design?
What is normalization? Explain different levels of normalization?
Write short notes on manual refreshes.
How long can an error message be in raiseerror function?
What are the 18 schemas?
In which table collections errors are stored.
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to use timestamp datatypes
Explain about relational database management systems?
What is dbms explain in brief?
Which four data types cannot be used as a return type from a user-defined function?
Write the fastest query to find out how many rows exist in a table?
Explain the cube operator?
