IT Community - Software Programming, Web Development and Technical Support

why use sql distinct

This is a discussion on why use sql distinct within the Database Support forums, part of the Web Development category; Hi all... Why use sql distinct? Thanks......


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 02-23-2008, 01:29 AM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 547
itbarota is on a distinguished road
Default why use sql distinct

Hi all...


Why use sql distinct?


Thanks...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-23-2008, 01:36 AM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 237
Pvinothkumar is on a distinguished road
Default Re: why use sql distinct

Hi all...


The DISTINCT keyword can help to understand information. For example, a query containing DISTINCT could return a non-duplicated list of cities where a company does business.


Thanks...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-03-2008, 01:18 AM
priyan priyan is offline
D-Web Sr.Programmer
 
Join Date: Mar 2007
Posts: 133
priyan is on a distinguished road
Default Re: why use sql distinct

Hi Vinoth,

We can arrive the same solution using GROUP By function, my question is which one is better in performance DISTINCT or GROUP BY ?
__________________
Keep smiling...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get distinct records from datatable oxygen C# Programming 1 03-05-2008 02:47 AM
Sql distinct itbarota Database Support 2 02-23-2008 01:40 AM
How can i use the sql distinct itbarota Database Support 2 02-23-2008 01:40 AM
How will get distinct values from datatable Mramesh C# Programming 5 02-14-2008 08:51 PM
Is it possible to create Stored Procedure in Dataset Using Distinct Key ? KiruthikaSambandam ASP and ASP.NET Programming 1 08-08-2007 08:03 AM


All times are GMT -7. The time now is 12:09 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0