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
- 14432 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravikumar
select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use online Backups?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How to replace not in with not exist?
Explain the cube operator?
How long can an error message be in raiseerror function?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain the process of the user request and data generating?
Explain about the storage and physical database design?
State the acid rules?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about relational database management systems?
How can I detect whether a given connection is blocked?
Who are naive users?
Explain about query and reporting.
