SQL SELECT TOP Clause
SQL SELECT TOP clause is used to retrieve top N records or by percentage value from specified table(s) and limits the records by mentioned value in the query. If you want to fetch records in...
by Manzoor Siddiqui · Published August 23, 2015 · Last modified October 18, 2015
SQL SELECT TOP clause is used to retrieve top N records or by percentage value from specified table(s) and limits the records by mentioned value in the query. If you want to fetch records in...
by Taiba Hamid · Published August 22, 2015 · Last modified October 18, 2015
The HAVING clause allows us to specify conditions on the rows for each group in combination with the GROUP BY clause (see the GROUP BY clause), the HAVING clause is evaluated after rows are...
Articles / SQL Server / Tutorials
by Manzoor Siddiqui · Published August 21, 2015 · Last modified September 24, 2015
500viewsMicrosoft database certification is important for database users as it helps in getting more job calls and short-listing your biodata and it certifies that you have completed almost all the topics of particular curriculum and...
by Manzoor Siddiqui · Published August 20, 2015 · Last modified September 24, 2015
SQL MAX() function returns the largest value from the selected column. Syntax SELECT MAX(columnName) FROM TableName To understand MAX() function we will take example from [SalesPerson] table of AdventureWorks2012 database. Below is a selection...
by Manzoor Siddiqui · Published August 19, 2015 · Last modified September 24, 2015
SQL MIN() function returns the smallest value from the selected column. Syntax SELECT MIN(columnName) FROM TableName To understand MIN() function we will take example from [SalesPerson] table of AdventureWorks2012 database. We are selecting all rows...
by Manzoor Siddiqui · Published August 18, 2015 · Last modified September 24, 2015
The SQL BETWEEN operator retrieves values within a specified range of SELECT, UPDATE, DELETE or INSERT commands and can be numbers, dates or text values. Here we will see examples for BETWEEN and NOT...
More