find highest salary

Answer Posted / qadeer

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 ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to set cookies?

606


How can you associate a variable with a session?

625


Explain mail function in PHP with syntax?

617


How can we increase execution time of a php script?

535


Why do we use namespace in php?

522






How do you pass a variable by value?

626


Why is node js better than php?

668


Tell me what does the array operator '===' means?

578


What is the difference between require and include in php?

558


Does php support multiple inheritance?

550


How can we encrypt the password using php?

612


Explain the different types of errors in php.

581


What is whitespace in html?

562


How to get no. of rows using MYSQL function?

629


How check submit button is clicked in php?

579