Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / srinivas
select max(salary) from Emp where salary<(select max(salary) from Emp)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why functions are used in sql?
what is top in tsql? : Transact sql
What are packages in pl sql and also explain its advantages?
how to enter binary numbers in sql statements? : Sql dba
Why are indexes and views important to an organization?
Why do we use function in pl sql?
What is dialect in sql?
What is full join in sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Does inner join return duplicate rows?
What is the basic form of sql query?
Describe types of sql statements?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Is natural join and inner join same?
Which join condition can be specified using on clause?