Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kavitha
select max(salary) from tablename where salary not in(select
max(salary) from tablename )
or
select max(salary) from tablename where salary <(select
max(salary) from tablename )
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is a filestream?
What is data mart? : sql server analysis services, ssas
What is the maximum rows in sql server table?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the query and subquery?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is Replication?
List out some of the requirements to set up a sql server failover cluster?
List out the differences between the clustered index and non-clustered index in sql server?
How do I know if localdb is running?
Describe and explain about SQL native client?
What are the different index configurations a table can have?
