Answer Posted / amruta dash
select max(salary) from tblname where salary not in (select
max(salary) from tblname);
Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
How to apply filtering criteria at group level with the having clause in ms sql server?
How to find index size for each index on table?
How to populate a table in sql server?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is create command?
How to access the inserted record of an event?
Explain go command in sql server?
Explain foreign key in sql server?
What is the difference between a primary key and a unique key? Are they the same?
What is the difference RDBMS and Graph Database?
whats the maximum size of view state??
is there a column to which a default can't be bound? : Sql server database administration
What is the use of nvl work?
What is view in sql?
Why union all is faster than union?