how to find the second highest salary from emp table?
Answer Posted / chaitanya pathak
select max(salary) from employee
where salary<(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is transaction? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
how to enter binary numbers in sql statements? : Sql dba
Are left and right joins the same?
What is nvl?
explain commit and rollback in mysql : sql dba
Why stored procedure is faster than query?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What has stored procedures in sql?
What mean sql?
What is the usage of nvl function?
Which function is used to return remainder in a division operator in sql?
What are the types of functions in sql?
What is pl sql record in oracle?
Name the operator which is used in the query for pattern matching?