Difference Between Primary Key and Secondary Key
PRIMARY KEY A primary key is a field that identifies each record in a database…
Difference Between In and Between Operator In SQL
In this article, we'll be discussing the comparison between IN and BETWEEN Operator in SQL.…
Explain Limit Keyword and ORDER BY Keyword in SQL
SQL LIMIT Keyword LIMIT keyword in SQL is often used for defining the range of…
How to Download And Install Xampp On Windows 10 ?
Xampp is a open source web server which comes up with handy tools like Apache,Tomcat,Filezilla…
How to Select Distinct Rows in SQL ?
The SELECT DISTINCT statement would let you get only unique information from a field that…
Connect to SQL from command prompt in Windows
After installing the Xampp for Windows, you can use command prompt for practicing SQL on…
Explain Like Keyword in SQL with Example
LIKE Keyword There may be a situation where you wanna fetch records from a table…
Check a Column Contains NULL or Empty using WHERE Clause in SQL
What is NULL? NULL represents an undefined. It cannot be counted as an empty string…
Explain AND, OR & NOT Operator in SQL
To make WHERE Clause function, operators are used for the purpose so that one can…
What are the types of SQL commands with Example ?
SQL is a query language that is very popular nowdays for accessing, modifying and retrieving…