Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / sushant hole
select max(salary) from employees where salary<(select max(salary) from
employees);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is partition in sql query?
What is write ahead logging in sql server?
What are different clauses used in sql?
how to enter characters as hex numbers? : Sql dba
How do I trace sql profiler?
What is a schema? How is it useful in sql servers?
How do I run a script in sql developer?
How do I make sql search faster?
write an sql query to find names of employee start with 'a'? : Sql dba
what are the different type of sql's statements ? : Sql dba
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Does view store data in sql?
How do we accept inputs from user during runtime?
What is union, minus and interact commands?
Can a commit statement be executed as part of a trigger?