Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 33557 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / arun ashok
Select max(salary) from employee where salary not in (select
max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is update locks?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What stored by the msdb?
Ms sql server index?
Define views.
how can you check the level of fragmentation on a table? : Sql server administration
What is the syntax to execute the sys.dm_db_missing_index_details?
How to change the name of a database user?
What are the disadvantages of merge replication?
What are “unrepeatable reads”?
What is difference between line feed ( ) and carriage return ( )?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Do you know what is a linked server in sql server?
What new changes are being made in SQL Server?
What is sql profiler. What are the default templates with it? : sql server database administration
