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
can a database be shrunk with users active? : Sql server administration
In case you have filters in your report, when filters will be applied in cached report instance?
What is the xml datatype?
What is the recovery model? List the types of recovery model available in sql server?
How to delete a login name in ms sql server?
List some advantages and disadvantages of stored procedure?
Explain log shipping and mention its advantages.
Write the SQL query to drop, truncate and delete table.
What is named query? : sql server analysis services, ssas
What are the advantages of partitioning?
Create and insert into temp table in sql server?
What stored procedure can you use to display the current processes?
What is the recursive stored procedure in sql server?
What are different types of collation sensitivity?
What is the downside of using udf?
