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
- 59359 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / ranjith
Select Max(Salary) from emp_database where Salary < (Select
Max(Salary) from emp_database)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the lambda triggers?
What are group functions in query statements in ms sql server?
Can we shrink data file in sql server?
Explain stored procedure?
When would you use it?
How do I determine how many instances of sql server are installed on a computer?
Define constraints and give an example of their use?
What is a bit datatype?
How to list all tables in the database using odbc_tables()?
Is foreign key unique?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is the datatype of rowid?
What types of Joins are possible with Sql Server?
Difference between drill down and drill through report.
How do you clear a log file?
