T-SQL – GROUP BY Clause
The SQL Server GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. The GROUP BY clause follows the WHERE clause in a SELECT statement…
T-SQL – ORDER BY Clause
The MS SQL Server ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some database sort query results in ascending order…
T-SQL – LIKE Clause
The MS SQL Server LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator − The percent…
T-SQL – WHERE Clause
The MS SQL Server WHERE clause is used to specify a condition while fetching the data from a single table or joining with multiple tables. If the given condition is satisfied, only…
T-SQL – DELETE Statement
The SQL Server DELETE Query is used to delete the existing records from a table. You have to use the WHERE clause with the DELETE query to delete selected rows, otherwise, all…
T-SQL – UPDATE Statement
The SQL Server UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update selected rows otherwise all the…
T-SQL – SELECT Statement
SQL Server SELECT statement is used to fetch the data from a database table which returns data in the form of a result table. These result tables are called result-sets. Syntax Following is…
T-SQL – INSERT Statement
The SQL Server INSERT INTO statement is used to add new rows of data to a table in the database. Syntax Following are the two basic syntaxes of the INSERT INTO statement.…
T-SQL – Drop Tables
The SQL Server DROP TABLE statement is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table. Note − You have to be careful while…
T-SQL – Create Tables
Creating a basic table involves naming the table and defining its columns and each column's data type. The SQL Server CREATE TABLE statement is used to create a new table. Syntax Following…