Given an employee table, how would you find out the second
highest salary?
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
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?
How long can an error message be in raiseerror function?
How to use timestamp datatypes
Why does this query return 0?
How can I detect whether a given connection is blocked?
explain detail about ftp in datastage?
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?
How to read and create .LDC data files which are used by linguatic dictionary.
fact table and dimension table containg one to many relationship or many to one relastionship
How to generate OIDS
In which database can extended stored procedures be added?
Explain about a primary key?
Write the fastest query to find out how many rows exist in a table?
How to replace not in with not exist?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on