Selecting Only Distinct Rows Or Entries From A Table

Tutorials Shared by the Internet Community

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: 20228

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 155 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 36.77%  57
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.97%  17
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12.26%  19
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.61%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.39%  44

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