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
How to create new table with "create table" statements?
What is the command used to check locks in microsoft sql server?
What are the benefits of filtered indexes?
What is the difference between lock, block and deadlock? : sql server database administration
What are drillthrough reports?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is sql azure database?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is difference between createstatement and preparedstatement?
how many bits ip address consist of? : Sql server database administration
What part does database design plays a role in performance of an sql server-based application?
How to test subquery results with the exists operator?
Call by value and call by reference in procedure and function, with NOCOPY.
Can we call stored procedure in trigger?
Explain about Normalization?
