Categories
SQL Server Step By Step

SQL Distinct

SQL Distinct Hi friends, in this post we will learn about SQL Distinct. Distinct keyword is used to get distinct (different) values. SQL DISTINCT keyword is used in with SELECT statement, it eliminate all the duplicate records and fetching only unique records. Earlier we had discussed about SQL Group by Clause,SQL Order By Clause,SQL Select Top Clause, Like Clause SQL […]

Categories
SQL Server Step By Step

SQL Group by Clause

SQL Group by Clause Hi friends, in this post we will learn about SQL Group by Clause. Group By clause is used to group the result. Earlier we had discussed about SQL Order By Clause,SQL Select Top Clause, Like Clause SQL Server, SQL AND & OR Operators, SQL Where Clause, Delete Query SQL Server, SQL Update Statement, SQL Select Statement, SQL […]

Categories
SQL Server Step By Step

SQL Order By Clause

SQL Order By Clause Hi friends, in this post we will learn about SQL Order By Clause. Order by clause is used to sort the result by one or more columns. By default ORDER BY clause sorts the results in ascending order. To sort the result in descending order you have to use DESC keyword. Earlier we […]

Categories
SQL Server Step By Step

SQL Select Top Clause

SQL Select Top Clause Hi friends, in this post we will learn about SQL Select Top Clause. Top clause is used to get TOP N number of records from table. Top clause can be very useful on tables with thousands of records. Fetching a large number of records can impact performance, so TOP clause is […]