MYSQL Data types

In this post we will look into the different data types of MySQL. it is very important to understand the data types in database testing. we can writing server test cases around it also can verify that proper data types are applied on…

Top 15 SELECT SQL queries

Here Top 15 most used and asked SELECT sql queries in interview. I have consolidated in one post.1) Find the Employee who get the second highest Salary.Answer:  SELECT emp_name from emp WHERE emp_salary =(SELECT max(emp_salary) FROM emp…