Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 58863 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / rajeev
select salary-1 from users where salary in (select
max(salary) from users);
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is open database communication (odbc)?
How to count rows with the count(*) function in ms sql server?
What are three major types of constraints?
What is a mutating table error and how can you get around it?
What is RMS migrations?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What are the properties and different types of sub-queries?
What is equi join with example?
What are the diifferences between the ms sql server vs mysql?
What is a user-defined function in the sql server and what is its advantage?
Does sql server use t sql?
How can you insert null values in a column while inserting the data?
What is the default Port No on which SQL Server listens?
What are various aggregate functions that are available?
What do you understand by a view? What does the with check option clause for a view do?
