Interested to Buy Any Domain ? << Click Here >> for more details...
Given an employee table, how would you find out the second
highest salary?
- 9 Answers
- 14192 Views
- I also Faced
- E-Mail Answers
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 is the physical representation for a many-to-many relationship?
What are the 18 schemas?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is an application role and explain a scenario when you would use one?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about relational database management systems?
What are the three types of database design?
Which data type cannot be used as a parameter in a udf?
Explain about the database management systems.
What are the three basic rules which are to be followed for the relational model of the database?
What are the main phases of database development?
How you can make a parameterized view?
How to read and create .LDC data files which are used by linguatic dictionary.
What is the maximum length of an extended property?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
