Scribd
Upload
9 views

DISTINCT in SQL - 1keydata

Uploaded by

vickroid007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views

DISTINCT in SQL - 1keydata

Uploaded by

vickroid007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

3/2/2016 DISTINCT in SQL | 1Keydata

SQL DISTINCT

SQL Data Warehousing CSS PHP HTML Database Normalization

SQL Tutorial
Basic SQL Commands
SQL SELECT
SQL DISTINCT
SQL WHERE SQL > SQL Commands > Distinct
SQL AND OR
The SELECT keyword allows us to grab all information from a column (or columns) on a table. This, of course, necessarily m
SQL IN
will be redundancies. What if we only want to select each DISTINCT element? This is easy to accomplish in SQL. All we ne
SQL BETWEEN
DISTINCT after SELECT. The syntax is as follows:
SQL Wildcard
SQL LIKE SELECT DISTINCT "column_name"
SQL ORDER BY FROM "table_name";
SQL GROUP BY
SQL HAVING For example, to select all distinct stores in Table Store_Information,
SQL ALIAS
SQL AS Table Store_Information
SQL SELECT UNIQUE
Store_Name Sales Txn_Date
SQL JOIN
SQL INNER JOIN Los Angeles 1500 Jan-05-1999
SQL OUTER JOIN San Diego 250 Jan-07-1999
SQL LEFT OUTER JOIN Los Angeles 300 Jan-08-1999
SQL CROSS JOIN Boston 700 Jan-08-1999
SQL INSERT INTO
SQL INSERT INTO SELECT we key in,
SQL UPDATE
SQL DELETE FROM SELECT DISTINCT Store_Name FROM Store_Information;

Advanced SQL
Result:
SQL UNION
SQL UNION ALL
Store_Name
SQL Inline View
Los Angeles
SQL INTERSECT
San Diego
SQL MINUS
Boston
SQL LIMIT
SQL TOP
SQL Subquery
SQL EXISTS Google Drive For Work
SQL CASE Unlimited Storage For Your Docs, Slides And Spreadsheets ­ $10/Month
SQL DECODE
SQL AUTO INCREMENT
SQL IDENTITY
Exercises
SEQUENCE & NEXTVAL

SQL Functions For these exercises, assume we have a table called Users with the following data:
SQL Average
SQL COUNT Table Users
SQL MAX
First_Name Last_Name Birth_Date Gender Join_Date
SQL MIN
Sophie Lee Jan-05-1960 F Apr-05-2015
SQL SUM
Richard Brown Jan-07-1975 M Apr-05-2015
SQL ROUND
Jamal Santo Oct-08-1983 M Apr-09-2015
String Functions
Casey Healy Sep-20-1969 M Apr-09-2015
SQL CAST
Jill Wilkes Nov-20-1979 F Apr-15-2015
SQL CONVERT
SQL CONCATENATE
1. Which of the following SQL statement is valid?
SQL SUBSTRING
a) SELECT DISTINCT * FROM Users;
SQL INSTR b) SELECT DISTINCT First_Name FROM Users;
SQL TRIM c) SELECT DISTINCT First_Name Last_Name FROM Users;
http://www.1keydata.com/sql/sqldistinct.html 1/2
3/2/2016 DISTINCT in SQL | 1Keydata
c) SELECT DISTINCT First_Name Last_Name FROM Users;
SQL LENGTH
SQL REPLACE 2. What's the result of the following query?
SQL TO_DATE SELECT DISTINCT Join_Date From Users;
Date Functions
3. What's the result of the following query?
SELECT DISTINCT Gender, Join_Date From Users;

Show Answers

Next: SQL WHERE

Real­Time WPF Charts


Plot many millions of data­points! 30 Day Free Trial Available Online.

Copyright © 2016 1keydata.com All Rights Reserved Privacy Policy About Contact

http://www.1keydata.com/sql/sqldistinct.html 2/2

You might also like