Differences between UNIQUE and DISTINCT in select statements
Answers were Sorted based on User's Feedback
Answer / kkparambath
SELECT DISTINCT Example
The "Persons" table:
P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger
Now we want to select only the distinct values from the
column named "City" from the table above.
We use the following SELECT statement:
SELECT DISTINCT City FROM Persons
The result-set will look like this:
City
Sandnes
Stavanger
Is This Answer Correct ? | 7 Yes | 9 No |
Answer / chandrakant agrawal
Let us try one using :
select distinct dept_name
from departments;
What this query would return if dept_name column contains
NULL values.
Is This Answer Correct ? | 3 Yes | 11 No |
Answer / satish parashar
After applying the unique clause all the value of column
will be sorted, But in distinct clause it only remove the
duplicacy from the table,not sorted the column value.
Is This Answer Correct ? | 6 Yes | 15 No |
Answer / apparao akki
Hi all,
plz find the below executed report on the same.
------------------------------------------------------
SQL> select * from person;
PERSON_ID FIRST_NAME LAST_NAME
TITLE_1 TITLE_2 SOCS
---------- --------------------- -------------------------
---------- ---------- -----------
9 ssss rrrrr
tttt gggg 67778-3
1 THUUTHTUT lofstrom
ba null 4940-343
1 ffsdf fsdfsd
fdsfsd fsdf 5454
1 THUUTHTUT lofstrom
ba null 4940-343
1 THUUTHTUT lofstrom
ba null 4940-343
1 appa akki
s/w btech 3i
2 rao
s/w kmm 3i
4 bunny neel
lkg ukg home
8 rows selected.
SQL> select unique(person_id),last_name from person;
PERSON_ID LAST_NAME
---------- -------------------------
2
1 lofstrom
4 neel
1 fsdfsd
9 rrrrr
1 akki
6 rows selected.
SQL> select distinct(person_id) from person;
PERSON_ID
----------
4
9
2
1
Is This Answer Correct ? | 9 Yes | 20 No |
Answer / vidya
unique allows null value but distinct does not consider
null value
Is This Answer Correct ? | 2 Yes | 44 No |
Is it possible to link two groups inside a cross products after the cross products group has been created?
Which query operators in sql is used for pattern matching?
What is pragma in sql?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.
Can we write ddl statements in functions?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is duration in sql profiler trace?
what is Difference between Having and Where clause?
what is switch column,colums cost in oracle?
What are the Diff B/W Cursor and REF Cursor
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
Write a query to find the names of users that begin with "um" in sql?