Second and Third Highest Salary using mysql

It is very easy to find second highest salary

SELECT *
FROM emp
WHERE salary =(SELECT salary
FROM emp
GROUP BY salary
ORDER BY salary DESC
LIMIT 1 , 1)

Third highest salary you can find following ways

SELECT *
FROM emp
WHERE salary =(SELECT salary
FROM emp
GROUP BY salary
ORDER BY salary DESC
LIMIT 2 , 1)


Most Popular

Tutorials Programme

Image
Loops Tutorials     Example While Loop #include <stdio.h> int main() { int count; count = 0; while (count < 4) { printf("The value of count is %d\n", count); count += 1; } return 0; } /* Result The value of count is 0 The value of count is 1 The value of count is 2 The value of count is 3 */
Keep reading

How to get table count for all tables in a database in Mysql?

Following Example shows you how to get tables list from database using PHP CODE. <?php $dbname = 'mysql_dbname'; if (!mysql_connect('localhost', 'root', '')) {     echo 'Could not connect to mysql';     exit; } $sql = "SHOW TABLES FROM $dbname";$result = mysql_query($sql); if (!$result) {     echo "DB Error, could not list tables\n";     echo 'MySQL Error: ' . mysql_error();     exit; } while ($row = mysql_fetch_row($result)) {     echo "Table: $row[0] \n"; } mysql_free_result($result);?>
Keep reading