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 second highest salary from an employee table using SQL is a classic problem the job seekers often face as┬átheir interview question. 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 very trivial but finding second highest is bit … Continue reading “SQL Query to Find Second Highest Salary”