SQL – MIN Function
SQLÂ MINÂ function is used to find out the record with the minimum value among a record set. To understand MIN function, consider an employee_tbl table, which is having the following records â SQL> SELECT *…
SQL – MAX Function
SQLÂ MAXÂ function is used to find out the record with the maximum value among a record set. To understand MAX function, consider an employee_tbl table, which is having the following records â SQL> SELECT *…
SQL – COUNT Function
SQL COUNT function is the simplest function and very useful in counting the number of records, which are expected to be returned by a SELECT statement. To understand the COUNT function, consider an employee_tbl table, which…
T-SQL – Functions
MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions â SQL Server COUNT Function â…
T-SQL – Indexes
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a…
T-SQL – Transactions
A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a…
T-SQL – Stored Procedures
The MS SQL Server Stored procedure is used to save time to write code again and again by storing the same in the database and also get the required output by passing…
T-SQL – Sub-Queries
A sub-query or Inner query or Nested query is a query within another SQL Server query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main…
T-SQL – Joining Tables
The MS SQL Server Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using…
T-SQL – DISTINCT Clause
The MS SQL Server DISTINCT keyword is used in conjunction with the SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a situation when you…