How to find third maximum salary from salary table?

admin

10 years ago

You can get the 3rd maximum salary as :

SELECT MIN(Emp_Salary) FROM Salary WHERE Emp_Salary IN(SELECT TOP 3 Emp_Salary FROM Salary ORDER BY Emp_Salary DESC)

What is the difference between echo and print in php

What is the difference between include and require?

Differences between GET and POST methods

How we can retrieve the data in PHP from MySQL

How to define a constant in PHP ?

Difference between mysql_connect and mysql_pconnect?

What are types of errors in PHP??

What is PEAR in php?

What is the default time of session in PHP?

What is maximum data size php session can hold?

Effect of deleting cookie on sessions

How do you get the value of current session id?

What does myisamchk do?

How to find third maximum salary from salary table?

What are the different Engines present in mysql?

Late Static Binding In Php Example

How to get current date and time in php

Set default timezone in php

php default timezone india

Conversation between two time zone

Refresh page using PHP

PHP Set HTTP header to UTF-8

PHP convert string to number

Php Force to download a file