Chapter 4 – What is SQL Server Distinct Statement and What is Operators in SQL Server in Hindi

Above video covers below topics of MS SQL Server:

• Distinct Command
• SQL Operators
• SQL Where Condition
• Greater than
• less than
• equal to
• less than equal to
• greater than equal to
• Between
• Like
• SQL In

Questions?

• What is SQL Distinct Command?
• how to select distinct records from sql server table?
• What is use of SQL Operators?
• how to use between in where command in sql server SQL?

Select Distinct Statement: SQL Distinct Statement is used to get only distinct (Different) Value From SQL Table.

Syntax:

Select Distinct Column1,Column2,Column3.. From Table_Name

Example:

Select Distinct EmployeeName From Employee

Solve Below Problem:

1. Select List of distinct City Name from Employee

2. Select distinct City Name and Salary of Employee

3. Select distinct City Count of Employee

Where Clause: Where Clause is used to filter records. Where clause is used to extract only those records that fulfill only specified conditions. It is also used in Update and Delete Statement.

We use Operators in Where Clause