how to find 2nd highest salary in random database salary of employer.....
Answer Posted / pankajbisane
select emp_name, salary from employee where salary = (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 a blob datatype?
What is new mysqli?
Why do we write stored procedures?
What is “i_am_a_dump” flag in mysql?
What is a tinyint?
What do I do if I forgot my mysql root password?
Is oracle better than mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is the difference between procedure and function in mysql?
what are the different tables present in mysql? : Mysql dba
What is difference between mysqli and pdo?
What is orm in mysql?
What is the default port for MySQL Server?
What is bigint in mysql?
What does mysqli stand for?