Learn2Done

SELECT INTO statement copies data from one table to new table. Syntax: SELECT * INTO new_table FROM old_table WHERE condition;...

To copy record from one table to another table INSERT INTO SELECT statement is used. In this statement the data...

To specify multiple values in WHERE clause, we use IN operator. IN operator is mainly used when there are multiple...

Select statement is used to fetch data from a table. Mainly the data is fetched by two ways using select...

Select statement is used to fetch data from a table. Mainly the data is fetched by two ways using select...

MIN() function: It returns the minimum(smallest) value of the selected column. Syntax: SELECT MIN(column_name) FROM table_name WHERE condition; DEMO STUDENTS TABLE:...

Count() Function: It returns the number of rows in selected column. Syntax: SELECT COUNT(column_name) FROM table_name WHERE condition; SAMPLE STUDENTS DATABASE:...

To get a specific number of records TOP clause is used. It is helpful when the data is large because...

To check weather there is a null value or not, we use IS NULL or IS NOT NULL operators. IS NULL...

The DELETE statement is used to delete the existing record/records in a table. Syntax: DELETE FROM table_name WHERE condition; DEMO...