This is the extension of the article of finding the second highest salary. Here we’ll see how to find the N-th highest salary. It is more generic version which is applicable for second highest also. Lets consider this employee table. DBMS Independent Way Here we’ll not use any DBMS specific keywords. This SQL query should … Continue reading “SQL Query to Find the N-th Highest Salary”
Category: Database
How to Access MySQL Database from C Program?
MySQL is an open sourcce database management system (DBMS). It is very popular among the web developers as it is part of LAMP (Linux, Apache, MySQL, PHP/Perl/Python) stack. Many popular large scale websites like WikiPedia, Facebook, Youtube use this database. Many times we need to use access MySQL database from C program. Here we’ll see … Continue reading “How to Access MySQL Database from C Program?”
SQL Query to Find Second Highest Salary
Finding the second highest salary from an employee table is a classic SQL problem the job seekers often face in their interview. Database programmers also have to solve similar problem like finding Nth highest number from a table. Finding the maximum salary from an Employee table is trivial. But finding the second highest is a tricky … Continue reading “SQL Query to Find Second Highest Salary”