In this article, we will learn how to use the DISTINCT keyword with a SQL select query.
Inside a table, a column may contain many duplicate values; To select only different (distinct) values from a database in SQL SELECT DISTINCT statement is used.
In this article, we will learn how to write a SQL select query.
To select data from a database in the SQL Select statement is used. The data returned is stored in the form of a result table, called the result-set.
We can use Select in two ways either select all the fields available in the table or can specify field names of the table from which you want to select data.
In this article, we will learn how to write a SQL delete query.
To delete the existing data in the SQL Delete statement is used.
In this article, we will learn how to write a SQL delete query with Where condition.
To delete the existing data in the SQL DELETE statement is used.
To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.
In this article, we will learn how to write a SQL update query.
To modify the existing data in the SQL UPDATE statement is used.
In this article, we will learn how to write a SQL update query with Where condition.
To modify the existing data in the SQL UPDATE statement is used.
To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.
In this article, we will learn how to write a SQL insert query.
