write a query for the fifth highest salary?
Answer Posted / bhramar
select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What will happen non-clustered index will be created on clustered index?
What is table scan and index scan?
How to do Data integrity testing? Who does this testing (Developer or tester)?
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
How much does it cost to build a database?
What is global database name?
define primary key index, bitmap index, hash index,virtual indwx
How do database connections work?
What is ole db ado?
What is ole db used for?
diff b/w inter process and in process
Is data lake a database?
What are the tools used for backup and ticketing?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
How many types of normalization? What is the use of it?