Javarevisited

The error "java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test" occurs when you try to connect ...

Hello guys, if you are interested in learning SQL with MySQL database and looking for some awesome resources e.g. books, tutorials, and onl...

The Select command in SQL is one of the most powerful and heavily used commands. This is I guess the first command anyone learns in SQL e...

There are two kinds of OUTER joins in SQL, LEFT OUTER join and RIGHT OUTER join. The main difference between RIGHT OUTER joins and ...

One of the most common SQL interview questions is to find the Nth highest salary of employees, where N could be 2, 3, 4 or anything e.g. fi...

Hello guys, if you are a Java developer and wondering how to connect to MySQL database from Spring Boot Java application then you have come ...

How to find duplicate records in a table is a popular SQL interview questions which have been asked as many times as difference between tr...

How to find the second highest or second maximum salary of an Employee is one of the most frequently asked SQL interview questions similar...

Many times we need to create backup or copy of tables in databases like MySQL, Oracle, or PostgreSQL while modifying table schema like add...

It's hard to remember the exact syntax of, how to create a stored procedure in MySQL until you are creating and working on stored proc...

Hello guys, if you are working with MySQL database in Linux and looking for MySQL commands to perform common tasks like starting and stoppin...

Truncate and delete in SQL are two commands which are used to remove or delete data from a table. Though quite basic in nature both SQL co...

The main difference between the Primary key and the Foreign key in a table is that it’s the same column that behaves as the primary key in...

Referential Integrity is a set of constraints applied to foreign keys which prevents entering a row in the child table (where you have the...

How to add a column in the existing table with a default value is another popular SQL interview question asked for Junior level program...

Automatic incremented ID, Sequence, or Identity columns are those columns in any table whose value is automatically incremented by databas...

Three tables JOIN Example SQL Joining three tables in a single SQL query can be very tricky if you are not good with the concept of SQL J...

How do you find names of all tables in a database is a recent   SQL interview question asked to one of my friends. There are many ways to ...

Hello guys, if you are struggling to write a sub query in SQL and need some guidance then you have come to the right place. In this articl...

A database transaction is an important concept to understand while working in databases and SQL. Transaction in the database is required ...