Given an employee table, how would you find out the second
highest salary?
Answer Posted / rony sunny
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 2 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the three basic rules which are to be followed for the relational model of the database?
How can you fix a poorly performing query?
Explain about post-relational databases?
What are the 18 schemas?
Where is dbms used?
What are data modelling techniques?
I have a few records all are same structures data, I want to store data in multiple targets how
What are the key features of dbms?
What is dbms and its application?
Explain about the hierarchical model of the database?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is database design and development?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What is normalization? Explain different levels of normalization?
Explain about xml databases?