select Nth highest salary by using rownum
Answer Posted / siva kumar
select rownum,empno,ename,sal from(select * from emp order by
sal desc)group by rownum,empno,ename,sal having rownum='&n'
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Compare non-clustered and clustered index
What is an example of a database?
What's the difference between delete and truncate ?
Explain vdl (view definition language)?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What is normalization in dbms?
What is the difference between horizontal and vertical partitioning?
Explain primary key and composite key.
Where is database stored?
Why normalisation is required?
What is a hierarchical database?
What is database management system with example?
Which is better saving files in database or in file system?
Explain the scenarios or situations under which progress database creates new index entry for a record?
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??