Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20879 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / satish
select salary from emp_Table_1 where 2= (select count(*)
form emp_Table_2 where emp_Table_2.salary < emp_Table_1.salary)
-satish
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the 3 types of schema?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is use of except clause?
Do you know what are different types of replication in sql server?
What does dml stand for?
How to perform backup for certificates in sql server? : sql server security
Why do we backup Active Directory ?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Why Master database is required?
Explain what is lock escalation and what is its purpose?
What is the difference between inner join and equi join?
Can you please differentiate between a primary key and a unique key?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
