Category Archives: sql

SQL – DISTINCT Keyword Table of content The SQL DISTINCT Keyword The SQL DISTINCT keyword is used in conjunction with the SELECT statement to fetch unique records from a table. We use DISTINCT keyword with the SELECT statetment when there is a need to avoid duplicate values present in any specific columns/tables. When we use […]

SQL – INSERT Query Table of content The SQL INSERT INTO Statement The SQL INSERT INTO Statement is used to add new rows of data into a table in the database. Almost all the RDBMS provide this SQL query to add the records in database tables. Each value in the records we are inserting in […]

SQL – SELECT Query Table of content The SQL SELECT Statement The SQL SELECT Statement is used to fetch the data from a database table which returns this data in the form of a table. These tables are called result-sets. CLAUSES and OPERATORS available in SQL can be used with the SELECT statement in order […]