HomeОбразованиеRelated VideosMore From: Jamie King

SQL DISTINCT Within a SELECT - Retrieving Unique Values

40 ratings | 21035 views
Jamie King of Neumont University demonstrating use of DISTINCT within a SQL SELECT command.
Html code for embedding videos on your blog
Text Comments (2)
PRANJAL AHLUWALIA (7 months ago)
Where can we get this Northwind database?
scorpiomaj27 (1 year ago)
This got me 90%, but one thing to be clear about, seems like in my testing DISTINCT applies to the FULL row, so if you have a second column you could get more than 1 row for each category ID if column B varied, for instance: Row1: Category ID 1, Category Type 1 Row2: Category ID 1, Category Type 2

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.