Selecting Only Distinct Rows Or Entries From A Table

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Selecting Only Distinct Rows Or Entries From A Table

The SELECT DISTINCT statement functions in much the same way as a standard select statement but will only return distinct column values.
http://www.basewebmaster.com/sql/select-distinct.php
  • Total Hits: 12066

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 144 votes

  • Category: Basic SQL/

  • Submitted on: 2011-05-08 21:57:04

  • Submitted By: Tom Lucas

  • Set as Favorite

Description:

The SELECT DISTINCT statement functions in much the same way as a standard select statement but will only return distinct column values.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.19%  55
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.42%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.81%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.11%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.47%  41

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.





Advertisements
Advertisements