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
- 14193 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 is data stored in dbms?
What is the database development process?
What is the physical representation for a many-to-many relationship?
What is database design and development?
What are data modelling techniques?
Write short notes on manual refreshes.
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?
What are the key features of dbms?
Explain about network model?
What is normalization? Explain different levels of normalization?
Explain about relational operator join?
In which table collections errors are stored.
What are the three types of database design?
Explain about relational database management systems?
How to combine two function together?
