Eliminating Duplicates with SQL SELECT DISTINCT

Author: databasedev.co.uk | Published: 11th Jan 2006 | Visited: 997 times | Add Comment
Filed in: MS Access

Eliminate Duplicates with SQL SELECT DISTINCT: When you are working with the SQL SELECT statement, you will more than likely come across duplicate rows when viewing your query results. This should cause no real problems, and by using the SQL DISTINCT keyword in your SELECT statement you will be able to remove all duplicate rows from your query results.

Read Article

Sponsored Links

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

• dml single insert/select or bulk collect/forall Tom, i am currently designing a new database 10g Rel2 and would appreciate your advice on the following Which method would you advise for the following business process OPTION 1 ######## DECLARE CURSOR c1 IS SELECT ..........

• Customize the built in Outlook Select Names Dialog (or any other) In this article you will learn how to customize the built in Select Names Dialog and use different external Datasources for your own Di ...

• CodeSnip: How to Select the Records from a Table Following a Pattern In this code snippet, Deepankar examines how to select only specific records from a table commencing in a series (even series i.e. 2nd,4th,6th...records or odd series i.e. 1st,3rd,5th.... records and other simple series) in a single query. He provides a detailed analysis of the relevant SQL stateme ...

• Why I can't use stored function in select list of select function. Hi tom, Thanks for accepting my question. my question is why we can't we perform dml operation in query? thanks ga ...

• Unable to store dynamic select into cursor Dear Tom, I am writing a SP which is using two table as CREATE TABLE TEST2 ( AGE NUMBER, NAME VARCHAR2(60 BYTE), EMPID VARCHAR2(60 BYTE) ) INSERT INTO test2 VALUES (25,'sunil','7940'); CREATE TABLE INPUT_PARAM ( CO ...

• I want know how to prevent select for update from users without update grant. Hi Tom, Thank you for this space for doubts. I want know how to prevent select for update from users without update grant. Follow the example below: <code> create user test1 identified by test1; grant connect,resource to test1; create ...

• why the select keep generating redo? Hello,Tom: Good afternoon! I have 2 questions: q1: I delete all rows from a big table and dont commit ,I select count(*) from the table from another session, and i looked in the expain,I found every time the query generated some redos,why ...

Next: Sample Data Model for Employees and Qualifications