The SQL Distinct clause is used to remove duplicates from the result set of a select statement.
SELECT DISTINCT expressions FROM tables WHERE condition;
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
March 13, 2015 at 5:11 pm
The SQL DISTINCT Keyword is used in conjunction with SELECT statement to eliminate all the Duplicated records and fetching only unique records.
SELECT DISTINCT column_name1, column_name2,
from table_name
WHERE [condition];
select distinct ID, name,address
from Customers
where contry=”mexico”;
March 15, 2015 at 11:56 pm
DISTINCT IS USED TO AVOID DUPLICATE VALUES.
SELECT DISTINCT CITY FROM CUSTOMERS;
March 21, 2015 at 8:43 pm
DISTINCT is to avoid duplicate values
Select DISTINCT city FROM Customers
March 22, 2015 at 8:13 pm
select distinct city from customers;
March 22, 2015 at 8:14 pm
The DISTINCT keyword can be used to return only distinct (different) values.
select distinct city from customers;
March 23, 2015 at 2:36 am
the distinct keyword is used to avoid repeatative records.
select distinct city from customers;
March 23, 2015 at 6:00 pm
select distinct city from customers;
March 23, 2015 at 11:57 pm
distinct is used so multiple’s dont repeat
March 26, 2015 at 6:03 pm
The SQL Distinct clause is used to remove duplicates from the result set of a select statement.
SELECT DISTINCT expressions FROM tables WHERE condition;
March 28, 2015 at 11:00 pm
The SELECT DISTINCT statement is used to return only distinct values.
Select DISTINCT city FROM Customers
March 29, 2015 at 12:55 am
The SELECT DISTINCT is used to avoid duplication of records.
SELECT DISTINCT name from customers where City=London;
October 19, 2015 at 9:13 am
we need distinct to return different value and eliminate the duplicate from rows
SELECT distinct City from Customers;
October 20, 2015 at 1:07 am
Fetching unique records and eliminating duplicate recordsSELECT DISTINCT City FROM Customers
Navigation
Loading Questions
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
Edit Profile