The SQL SELECT DISTINCT Statement

 The SQL SELECT DISTINCT Statement

TUTORIAL IN HINDI:

The SELECT DISTINCT statement is used to return only distinct (different) values.

Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.

Example:

SELECT DISTINCT Student_City From STUDENT;

----------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------

SQL:

• The Structured Query Language (SQL) is the language of databases.
• All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block.
• In fact, it’s often the only way that you can truly interact with the database itself.
• All of the fancy graphical user interfaces that provide data entry and manipulation functionality are nothing more than SQL translators.
• They take the actions you perform graphically and convert them to SQL commands understood by the database.
• SQL is Similar to English
• Fortunately, at its core, SQL is a simple language.
• It has a limited number of commands and those commands are very readable and are almost structured like English sentences.

SQL Commands:

SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data.

Types of SQL Commands:

DDL:

DML:

DQL:

DCL:

TCL:

--------------------------------------------------------------------------------

Follow Us :-

YouTube: