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
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
what is tkprof tool and how it is used???
What is meant by distributed system?
What is difference between clustered, non-clustered and unique index?
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 ad-hoc access? what is the diff b/w managed query and ad-hoc access?
how do you do sql tuning?
What is Data Modelling?
What is database server and how it works?
What is the difference between oracle and MS Access?
Explain storage manager?
What is a database connection string?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
How is image stored in database?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?