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?”
Tag: Database
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”