When using the select statement there will be times when the return result will be duplicated. So how do we go about to retrieve only unique rows? The DISTINCT keyword can be used to retrieve the result with a unique rows.

SYNTAX:

SELECT DISTINCT "column_name" FROM "table_name"

EXAMPLES:

For example if we select all records from the Student table we would see the following 4 records:

SELECT LastName from Student;

Table: Student

When using the DISTINCT keyword we would see the following result:

SELECT DISTINCT LastName from Student;

Result:

LastName
Bob
Jane
John

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."