Tag Archives: DML

SQL UPDATE Statement – Syntax and Example of Updating Records

UPDATE Statement is used in SQL to change existing records in a table. This way, we can change one record, multiple records or all of them. Condition based on which are records restricted is placed in WHERE clause. Syntaxe – 3 Ways of UPDATE Usage A) Simple form: Change of the values in certain column… Read More »

SQL SELECT DISTINCT – Removing Duplicates from Table = Unique values

SELECT DISTINCT is a command used to show unique records in a table. Its use is broad but it is mainly used to remove duplicities in the records when taking multiple views on data. Hint: If we select more than 1 column, DISTINCT will return unique combinations of selected columns SELECT DISTINCT Syntax Syntax is… Read More »