We as a developer, often come across situations where we have to work on database related stuffs. Mostly it is done when client send you its data in form of excel sheets and you push that data to database tables after some excel manipulations. I have also done it many times. A very common problem […]
SQL Query to Find Nth Highest Salary of Employee
This is a very common interview question if you are going for the role at junior level. Most of the people learn it character by character, but few understand how this query works. How good or bad its performance is? In this post, we will learn these things. I am using MySQL database for demonstration. […]
SQLException: Access denied for user ‘root’@’localhost’ after re-installation of MySQL server
Have you ever faced problem of access denied or any login related issues after re-installing MySQL server. I faced this issue and when i googled it, I saw many others are also suffering from this problem frequently. In this post, I will suggest you a good try which will solve this problem in 95% of […]