Author: Shameer
•10:37 AM
SQL - DISTINCT


The DISTINCT keyword can be used to return only distinct (different) values.

Main Table


1.   SELECT DISTINCT Customer_Name 
         FROM customer


2. SELECT DISTINCT Customer_Name FROM customer WHERE Cus_Id = 5


3.       SELECT DISTINCT Customer_Name 
             FROM customer 
     ORDER BY Customer_Name


4.       SELECT DISTINCT Customer_Name 
            FROM customer 
    ORDER BY Customer_Name DESC


5.     SELECT DISTINCT Customer_Name, Order_Date 
          FROM customer


6.     SELECT DISTINCT Customer_Name, Order_Date 
          FROM customer 
       WHERE Cus_Id = 4


7.         SELECT DISTINCT Customer_Name, Order_Date 
              FROM customer
      ORDER BY Customer_Name, Order_Date



8.        SELECT DISTINCT Customer_Name, Order_Date 
              FROM customer
      ORDER BY Customer_Name, Order_Date DESC



9.         SELECT DISTINCT Customer_Name, Order_Date 
              FROM customer
      ORDER BY Customer_Name DESC, Order_Date DESC


This entry was posted on 10:37 AM and is filed under . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

22 comments:

On April 12, 2013 at 8:15 PM , Anonymous said...

Thanks for some other informative site. Where else may just I get that kind of info written in such an
ideal manner? I have a project that I'm just now working on, and I have been on the glance out for such info.

My web-site diets That Work

 
On May 23, 2013 at 12:03 AM , Anonymous said...

After drinking the sea-salt water flush. A successful liver cleanse
is a particularly widely used method that helps boost the natural texts to get
him backification process and also by regular intake of prescription drugs that
only use essence of different herbs. If not
some kind of malfunction of the ovary.

My homepage: webpage

 
On May 16, 2014 at 11:50 AM , Anonymous said...

It's the best time to make some plans for the future
and it is time to be happy. I have read this put up and if I could I desire to recommend you some fascinating
things or suggestions. Perhaps you could
write next articles referring to this article.
I want to read more things about it!

Feel free to visit my site clash of clans hack

 
On May 30, 2014 at 5:05 AM , Anonymous said...

Keep on working, gret job!

Review my web site - Staffing Agencies In Orange County Ca

 
On June 1, 2014 at 5:41 AM , Anonymous said...

It's a shame you don't have a donate button! I'd ceгtainly
doonate tօ thіs exceplent blog! ӏ suppose for now i'll settle forr bookmarkibg аnd
adding yоur RSS feed tօ my Google account. I look forward too
new updates аnd will talk about this website with my Facebook ցroup.
Chat ѕoon!

my web blog: Hay Day Hack Tool

 
On June 11, 2014 at 6:00 PM , Anonymous said...

Remarkable ideas. Investigation has revealed that it is powerful on the way to
appetite suppression weight using and increased vitality metabolism.
Garcinia Cambogia will be loaded with critical vitamins, fibers,
minerals and different healthy nourishment the human body requires.
Nowadays the question is what accurately happen to be the
features to selecting and implementing Garcinina? Let's get a
closer appear at Garcinia Cambogia success stories

my website - garcinia cambogia retailers

 
On June 11, 2014 at 6:02 PM , Anonymous said...

Just want to say your article is as astonishing.
The clarity in your post is just spectacular and i could assume
you are an expert on this subject. Well with your permission let me to grab your RSS
feed to keep up to date with forthcoming post. Thanks a million and please keep up the gratifying work.


Also visit my web blog; click here ()

 
On June 11, 2014 at 6:09 PM , Anonymous said...

Link exchange is nothing else but it is simply placing the other person's website
link on your page at appropriate place and other person will also
do same in favor of you.

Here is my blog; Eden Heights Kamp developers Kampdevelopers babes bachelor background searches* bad credit bald baldness banned CD* banned C D* banned filename bargain baseball basketball be a match beautiful bride bedroom satisfaction benin* best discount offers best motorola deal best prices best rate best rates bestial better life security big and bad big savings bigger breasts bigger dick bigger guys bigger size bigger than big bikini line biscom* bitch bitches b­i­z .biz black worm bleeding gums blind date BLOCKED ATTACHMENT (replaced with text) blocked delivery of email (blocked subject) blow your load blowout blowing blue pill boobs boost+reliability boyfriend* bracelet brain.+.+.+ breaking the habit breast breasts breath tester breathalyzer* britney* broadcast email bug announcement bug letter bug message bug notice bulk hosting* burn fat business opportunity buy or sell a home buy this stock Lose weight

 
On June 16, 2014 at 11:28 PM , Anonymous said...

you're in point of fact a good webmaster. The web site loading velocity is
amazing. It sort of feels that you're doing any distinctive trick.

Also, The contents are masterpiece. you've done a fantastic task on this subject!


Feel free to visit my web page ... google (google.com)

 
On June 18, 2014 at 8:10 AM , Anonymous said...

Siply desire tto say your articl is as surprising.
The clarity to your publish is just spectacular annd that i could
suppose you're an expert inn this subject. Well with your permission allow me
to clutch your feed to stay updatted with forthcoming post.
Thank you one million and please continue the rewarding
work.

my webpage; brave frontier cheat (http://www.squidoo.com/)

 
On June 19, 2014 at 8:49 PM , Anonymous said...

I just could not go away your web site before suggesting that I actually enjoyed the
usual information an individual supply to your visitors?
Is going to be again regularly to investigate cross-check
new posts

my web page ... white magic spells free - http://factorhumano.co/cfrt143/2013/10/23/un-texto-sin-arandelas -

 
On June 19, 2014 at 9:34 PM , Anonymous said...

You don't have to verify your brains at the doorway.
Sign up for my pet weblog and let me know if you have
concerns or issues regarding your animals. The unhappy truth is that your sexual companion may not even know they have a illness.


Here is my web site ... std tests at home

 
On June 29, 2014 at 3:46 PM , Anonymous said...

for a coffee and alfajor to recharge the batteries before taking the teleferico (Avenida San Martin y H.

There are many reasons to use a roll-up banner stand including
the fact that they can be put up within seconds and are easily transportable.
If you are the owner of a company, you should also organize corporate incentive travel for your valuable employees.


my web-site; prestige eyeliner

 
On August 6, 2014 at 11:19 AM , Anonymous said...

Magnificent goods from you, man. I've understand your stuff previous to and you're just too wonderful.

I actually like what you have acquired here, really like what you are
stating and the way in which you say it.
You make it enjoyable and you still take care of
to keep it sensible. I can not wait to read far more from you.

This is actually a great website.

Also visit my website :: nitrix

 
On September 7, 2014 at 12:22 PM , Anonymous said...

times when singer is not all the shipway in which feat a spiritedness
policy at whatsoever lie, they involve to. valuable accusation for a
user impute guidance service decide pass you much
options. If you use is crucial. A existent estate representative purpose
improve you to accept you a Oakley Sunglasses
Cheap Oakley Sunglasses Cheap Oakley Sunglasses Cheap Ray Ban Sunglasses Cheap Ray Ban Sunglasses Ray Ban Sunglasses noteworthy.
By changing speeds time you are decorating a littler established.

inactivity to hold your relationship online periodically to variety use of the majority of somesthesia in your books bought opportune when you selection out
wearable online you plausibly demand to papacy about aboutpolitics or your DoI plan if

Check out my web page; Cheap Ray Ban Sunglasses

 
On September 7, 2014 at 1:22 PM , Anonymous said...

Every weekend i used to visit this website, because i want enjoyment, since this this website conations actually good funny
information too.

my site: injustice gods among us hack no survey ()

 
On June 11, 2015 at 3:24 AM , Weight Loss Oracle said...

interesting post

 
On February 5, 2016 at 12:55 AM , Unknown said...

Great and Interesting post :).You can aso visit our website
Real Estate Project in L zone Dwarka

 
On June 9, 2016 at 4:01 AM , William Miracle said...

Nice to be visiting your blog again, it has been weeks for me. Well, this is the article that I’ve been waited for so long. Thanks, great share.
grow taller
height increase
become taller
growtaller4idiots
exercise to increase height
grow taller after puberty
grow taller fast
grow taller naturally

 
On December 18, 2019 at 3:29 AM , yanmaneee said...

moncler outlet
goyard handbags
golden goose sneakers
golden goose
supreme clothing
supreme t shirt
golden goose
yeezy
yeezy shoes
golden goose

 
On May 12, 2022 at 1:52 AM , Unknown said...

you could try here best replica designer helpful hints bags replica gucci see replica bags buy online

 
On July 13, 2022 at 8:38 PM , mctiso said...

replica bags by joy replica hermes j6a96c2k44 replica kipling bags Full Article x3o51m3o71 replica bags china replica bags thailand replica bags south africa this link p1k24q9d56 replica bags philippines