SQL : Select Query : Distint Clause

-
Introduction:
The DISTINCT clause allows you to remove duplicates from the result set. The DISTINCT clause can only be used with select statements.

The syntax for the DISTINCT clause is:
SELECT DISTINCT columnsFROM tablesWHERE predicates;

Example #1
Let's take a look at a very simple example.
SELECT DISTINCT categoryFROM ebooks;

This SQL statement would return all unique categories from the ebooks table.

Example #2
The DISTINCT clause can be used with more than one field.
For example:

SELECT DISTINCT category, publisherFROM ebooks;

This select statement would return each unique category and publisher combination. In this case, the distinct applies to each field listed after the DISTINCT keyword.

Comments

Post a Comment

Popular posts from this blog

23 Tips to Speed Up your Windows XP Performance

-
Given below are the 23 tricks that will enhance the performance and reliability of your Windows XP OS. Best of all, most of them will cost you nothing. 1-To decrease a system's boot time and increase system performance, use the money you save by not buying defragmentation software -- the built-in Windows defragmenter works just fine -- and instead equip the computer with an Ultra-133 or Serial ATA hard drive with 8-MB cache buffer. 2- If a PC has less than 512 MB of RAM, add more memory. This is a relatively inexpensive and easy upgrade that can dramatically improve system performance. 3- Ensure that Windows XP is utilizing the NTFS file system. If you're not sure, here's how to check: First, double-click the My Computer icon, right-click on the C: Drive, then select Properties. Next, examine the File System type; if it says FAT32, then back-up any important data. Next, click Start, click Run, type CMD, and then click OK. At the prompt, type CONVERT C: /FS:NTFS and press
Read more

How to uninstall McAfee Security Center from your System

-
If you want to uninstall McAfee Security Center, follow these steps. 1 - Access McAfee's files in your program files folder in Explorer. Look for C:\program files\mcafee.com\agent\app. 2 - Delete all files contained in the folder. If you can’t find the McAfee application, enter "mcafee" in the Search feature on your Explorer toolbar. 3 - Go to the "Add and Remove Programs" in the Control Panel. Highlight "McAfee Security Center" and click on "Remove."
Read more

What is a balanced scorecard?

-
The balanced scorecard methodology, an outgrowth of prior measurement and management methodologies like total quality management (TQM), has existed for decades, but it was formalised in the early 1990s by Robert Kaplan and David Norton. Kaplan and Norton not only gave it a formal name but also put structure around the way organisations can measure how well they are functioning and how to predict future performance. Basically, it's a way to map and translate complex business information into something that's understandable to everyone. The methodology starts with targets defined by the organisation, followed by scorecard measures. These usually include both corporate targets and business unit targets, which are then honed into individual measures and targets. It's a very flexible approach, designed to be adapted to any organisation's needs. And virtually anything can be measured.
Read more