Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997

Finding Unique Data

Question:
How would I change the following statement to yield only unique values?
    select * FROM WEBDBASE 
    where ST = '#State#' AND #SPECIALTY# = 'x';

Answer:
You can't get unique values when using SELECT *. However, you can specify the DISTINCT keyword immediately before the column name of the column that you'd like to be unique:

    SELECT DISTINCT st FROM Webdbase
    WHERE specialty = 'x';
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date