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
Give me any three differences between Truncate and Delete.
What happens when unicode strings concatenate with non-unicode strings?
What is the Main Difference between ACCESS and SQL SERVER?
Can a table be moved to different filegroup?
explain different types of constraints? : Sql server database administration
Do you know what are the properties of the relational tables?
What is check constraint in sql server?
How to recreate an existing index in ms sql server?
How can you insert values in multiple rows using one Insert statement?
What is resource governor?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How to enter binary string literals in ms sql server?
How do I find the query plan in sql server?
Do you know what is user defined datatypes and when you should go for them?
What is constraints and its types?