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
- 60214 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is mean by dml?
Please differentiate between a local and a global temporary table?
How to create a trigger for insert only?
Differentiate between a primary key and a unique key.
where the connection string store in the database
What is set nocount on?
When to use Inner join & when to use subquery?
What is user-defined inline table-valued function?
What is default constraint in ms sql server?
How to Insert multiple rows with a single insert statement?
Explain the categories of stored procedure?
How connect excel to sql server?
What is the command used to recompile the stored procedure at run time?
How do I perform an unattended install of sql server 2000?
Do you know how to send email from database?
