write a query for the fifth highest salary?
Answer Posted / chethan
select Salary from ( select salary from emp order by desc) as employee where rownum = 5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is the function of cluster index?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
how can we view column head in first page but not in remaining pages?
What is redis good for?
Data structure used to implements a menu:
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
What are the advantages of using database?
What do you mean by cluster and non cluster index?
Differentiate between unique key and foreign key?
What is the DIF format and when we will use in teradata
What is the use of default key?
can we delete autodiff back up that we have set through sql server agent.
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
Explain database partitioning.