Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / vsandhyana
select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc
Thanks
Vikram Sandhyana
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
hi my name is siraj i want to know cognos queriy language
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what are the filters in framework manager and report studio?
Name the types of report?
how to test reports in cognos?
hi friends pls forward impropmtu interview question
how to explain health care project and which reports we can create in health care doain?
What is the use of powerhouse?
What is meant by Reportstudio shortcut?
What are slice and dice?
What is difference between data mart and data warehouse?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
what is the procedure for scheduling conditional rendering?
how you create security to reports?