find highest salary

Answer Posted / renji

SELECT DISTINCT (
s1.salary
)
FROM `salary` s1
WHERE n -1 = (
SELECT count( DISTINCT (
s2.salary
) )
FROM `salary` s2
WHERE s2.salary > s1.salary )

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a select query that will be displayed the duplicated site name and how many times it is duplicated?

628


Does php need apache?

555


What are the rules for naming a php variable?

609


Can php variables have numbers?

606


What is the use of rand() in php?

658






Explain the difference between static and dynamic websites?

564


What is xss and csrf?

568


What is difference between isset and empty in php?

600


Explain how to submit form without a submit button.

595


Does php pass arrays by reference?

633


What is pdo in php why use?

552


How do you end php?

573


/temp is a type of filesystem directory. State Whether True or False?

648


What is final in php?

582


What is input sanitization in php?

599