SQL DISTINCT Command

Computer Programming Forums : Questions and Answers, Articles, Tutorials, and Code Snippets

Switch to full style
Include SQL commands
Post a reply
DrRakha
  • DrRakha
  • Posts: 2715
  • Joined: Tue Mar 27, 2007 10:55 pm
  • Location: Earth
  • Website

SQL DISTINCT Command

Sun Jul 15, 2012 10:49 pm

To avoid duplicate records in select query results you can use DISTINCT command :

Code:

SELECT DISTINCT * FROM Department


or you can limit it to a specific column :

Code:

SELECT DISTINCT departmentName FROM Department




Post a reply
  Related Posts  to : SQL DISTINCT Command
 BETWEEN SQL COMMAND     -  
 SQL ALTER Command     -  
 SQL GROUP BY Command     -  
 PHP echo command     -  
 Average SQL command     -  
 SQL COUNT Command     -  
 JVM does not recognize MQ command.     -  
 SQL LOCATE command     -  
 Calling the man Command     -  
 SQL LIKE query Command     -  
Switch to full style

Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com


Powered by phpBB © phpBB Group.


Codemiles.com