how to find the second salary?

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


Please Help Members By Posting Answers For Below Questions

How to apply filtering criteria at group level with the having clause in ms sql server?

550


How to find index size for each index on table?

578


How to populate a table in sql server?

494


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?

513


What is create command?

519






How to access the inserted record of an event?

566


Explain go command in sql server?

540


Explain foreign key in sql server?

569


What is the difference between a primary key and a unique key? Are they the same?

536


What is the difference RDBMS and Graph Database?

624


whats the maximum size of view state??

1710


is there a column to which a default can't be bound? : Sql server database administration

530


What is the use of nvl work?

558


What is view in sql?

555


Why union all is faster than union?

502