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
What is DB Development software?
Which data type cannot be used as a parameter in a udf?
How to use online Backups?
How to replace not in with not exist?
Explain about the hierarchical model of the database?
Explain about query and reporting.
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What are the three basic rules which are to be followed for the relational model of the database?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Write the fastest query to find out how many rows exist in a table?
In which database can extended stored procedures be added?
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?
Explain about relational database management systems?
Explain about network model?