learn anywhere, anytime
In this article, We’ll see how to find Second Highest Salary of Employee We’ve created a employees table i.e tbl_employees and added some records inside table. Query to find Second Highest Salary of Employee That’s it!. Please share your thoughts or suggestions in the comments below.
In this article, We’ll see how to remove duplicate records in mysql We’ve created a users table i.e tbl_users and added some records inside table. Delete duplicate records using Sub Query or We can use below sql query. After executed the query, we’ve removed the duplicate records from users table. That’s it!. Please share yourRead more about How to remove duplicate records in mysql[…]
In this article, We’ll see what is the difference between MyISAM vs InnoDB in MySQL ? InnoDB and MYISAM, are storage engines for MySQL. InnoDB is a storage engine for the database management system MySQL. MySQL 5.5, Dec 2010, and later use it by default replacing MyISAM. It provides the standard ACID-compliant transaction features, alongRead more about What is the difference between MyISAM and InnoDB?[…]
In this article, we’ll see about what does int(11) means in MySQL. most of the developer think that int(11) means in MySQL is that the int column can store maximum integer value with 11 digits in length. However, this is not true. in int(11), 11 is the display width of the integer column, unlike theRead more about What does int(11) means in MySQL?[…]