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
- 14544 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
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What are the 18 schemas?
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.
fact table and dimension table containg one to many relationship or many to one relastionship
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
Explain the role of indexing in databases?
Who are end users in dbms?
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?
What are the constraints on severity level in raiseerror?
What is the physical representation for a many-to-many relationship?
How can you log an error to the server event log from a stored procedure?
What are the three types of database design?
What is an application role and explain a scenario when you would use one?
How can you fix a poorly performing query?
Why does this query return 0?
