SQL SELECT TOP Statement

The SQL SELECT TOP syntax

The general syntax is:

  1. SELECT TOP n columnnames
  2. FROM tablename

 


 

SQL SELECT TOP

Problem: List top 10 most expensive products

  1. SELECT TOP 10 Id, ProductName, UnitPrice, Package
  2. FROM Product
  3. ORDER BY UnitPrice DESC

Results: 10 records.

Id ProductName UnitPrice Package
38 Côte de Blaye 263.50 12 – 75 cl bottles
29 Thüringer Rostbratwurst 123.79 50 bags x 30 sausgs.
9 Mishi Kobe Niku 97.00 18 – 500 g pkgs.
20 Sir Rodney’s Marmalade 81.00 30 gift boxes
18 Carnarvon Tigers 62.50 16 kg pkg.
59 Raclette Courdavault 55.00 5 kg pkg.
51 Manjimup Dried Apples 53.00 50 – 300 g pkgs.
62 Tarte au sucre 49.30 48 pies
43 Ipoh Coffee 46.00 16 – 500 g tins
28 Rössle Sauerkraut 45.60 25 – 825 g cans

Comments (134)

  1. 응답

    Oh my goodness! Awesome article dude! Thank you, However I am going through issues with your RSS.
    I don’t know why I am unable to subscribe to it.
    Is there anyone else getting the same RSS issues?
    Anyone that knows the solution will you kindly respond?
    Thanx!!

  2. 응답

    Asking questions are truly good thing if you are not understanding anything entirely, except this article offers fastidious understanding even.

  3. 응답

    I’m not that much of a online reader to be honest but your sites
    really nice, keep it up! I’ll go ahead and bookmark your site
    to come back later on. Cheers

  4. 응답

    Hi! This is kind of off topic but I need some guidance from an established blog.
    Is it difficult to set up your own blog? I’m
    not very techincal but I can figure things out pretty fast.
    I’m thinking about creating my own but I’m not sure where to begin. Do you have any
    tips or suggestions? Many thanks

  5. 응답

    I’m really impressed with your writing skills and also with the layout on your blog.
    Is this a paid theme or did you modify it yourself?
    Either way keep up the excellent quality writing, it’s rare to see a nice blog like this
    one these days.

  6. 응답

    I loved as much as you’ll receive carried out right here.
    The sketch is tasteful, your authored subject matter stylish.
    nonetheless, you command get bought an impatience over that you wish be delivering the following.
    unwell unquestionably come further formerly again since exactly the same
    nearly a lot often inside case you shield this hike.

  7. 응답

    Howdy! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog
    to rank for some targeted keywords but I’m not seeing very good success.
    If you know of any please share. Appreciate it!

    my page: Testo Blast Pills

  8. 응답
  9. 응답

    hi!,I love your writing so a lot! percentage we communicate
    extra about your article on AOL? I require ann expert on tbis house too resolve myy problem.
    Maybe that’s you! Looking forward to look you.
    https://ru-ru.facebook.com/plastic.surgery5
    отзывы об Иванчуке Максиме Сергеевиче
    отзывы об Иванчуке Максиме Сергеевиче https://ru-ru.facebook.com/plastic.surgery5

  10. 응답

    Ithink that everything publisahed made a greqt deal of sense.
    However, what about this? what if you added a little content?
    I mean, I don’t wish to tell you hhow to run your blog, but
    what if you added a post title to possibly gett a person’s
    attention? I mean SQL SELECT TOP Statement | 기록은 자산 is kinda boring.
    You ought to peek aat Yahoo’s home page and watch
    how they create article titles to grab viewers interested.

    You might add a video or a picture or two too grab
    people interested abbout everything’ve written. In my opinion,
    it migt bring your posts a little livelier.
    https://www.medcentre.com.ua/vrachi/ivanchuk-maksim-sergeevich.html
    отзывы об Иванчуке Максиме Сергеевиче
    отзывы об Иванчуке Максиме Сергеевиче https://www.medcentre.com.ua/vrachi/ivanchuk-maksim-sergeevich.html

  11. 응답
  12. 응답
  13. 응답

    Thanks for all your work on this blog. Ellie really likes conducting research and
    it’s really obvious why. Many of us notice all
    regarding the lively form you give important guides on this website and
    as well as invigorate participation from website visitors about this theme so my daughter is starting to learn a whole
    lot. Enjoy the rest of the new year. You have been carrying out a
    glorious job.[X-N-E-W-L-I-N-S-P-I-N-X]I am extremely inspired along with your
    writing skills and also with the structure in your weblog.
    Is that this a paid subject matter or did you customize it
    yourself? Either way keep up the nice quality writing, it is uncommon to peer a great weblog like this one
    today.

    My web site :: ReLeaf Ease CBD

  14. 응답
  15. 응답

    I don’t even know how I finished up right here,
    however I assumed this post used to be good. I do not recognise
    who you might be but certainly you’re going to a well-known blogger when you
    aren’t already 😉 Cheers!

  16. Pingback: Greenway Palms

  17. 응답

    I will not even know how I ended up here,
    but I assumed this submit used to be good.

    I tend not to recognise who you could be however
    certainly you’re visiting a famous blogger for individuals who are
    not already. Cheers!

    Here is my site … wallet combo

  18. 응답

    An interesting discussion is certainly worth comment.
    I truly do believe that you ought to write a
    little more about this subject, it might not be a taboo matter but typically people will not discuss
    these issues. To another! Cheers!!

    Also visit my website DenisAGechas

  19. 응답

    naturally like your website however you ought to check the spelling on several of the
    posts. Several seem to be rife with spelling problems and I to locate it very troublesome to know the truth on the other hand I’ll surely come again again.

    Also visit my blog post: DinaJBuehler

  20. 응답

    Having read this I believed it was rather informative.
    I appreciate you taking the time and effort to put this short article together.
    I once again find myself personally spending a lot of time both reading and commenting.
    But so what, it was still worth it!

    Feel free to visit my web page: Humboldts Best CBD Oil Reviews,
    ozarkstalk.com,

  21. 응답

    What’s Taking place i’m new to this, I stumbled upon this I
    have discovered It positively helpful and it has aided me out loads.
    I hope to contribute & aid different users like its aided me.
    Good job.

    my webpage; Premium Diet Keto Ingredients – woodw.o.r.t.h

  22. 응답

    Can I just say what a comfort to find somebody who really knows what they are talking about on the web.
    You certainly realize how to bring a problem to light and make
    it important. A lot more people need to read this and understand this side of your
    story. I was surprised that you aren’t more popular because you certainly possess
    the gift.

    Feel free to visit my web site … PrimaFreshia Keto Ketogenic Blend (http://ozarkstalk.com/entry.php?44749-Healthy-Eating-Tips-For-Losing-Weight-Fast)

  23. 응답

    Excellent beat ! I wish to apprentice at the
    same time as you amend your site, how can i subscribe for a weblog website?
    The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided brilliant transparent idea 0mniartist asmr

  24. 응답

    My coder is trying to persuade me to go to .net from PHP. We have always disliked the idea due to the costs.
    But he’s tryiong none the less. I’ve been utilizing Movable-type on numerous websites for roughly each year and am worried about
    switching to another platform. I have got heard good reasons for blogengine.net.
    What is the way I can import all of my wordpress content into it?

    Any sort of help could be really appreciated!

    Have a look at my webpage: credit card pocket

  25. 응답

    I am curious to find out what blog platform you are using?
    I’m having some minor security problems with my latest site and I’d
    like to find something more risk-free. Do you have any suggestions?

  26. 응답

    Hi to all, how is the whole thing, I think every one is getting more
    from this site, and your views are fastidious for new users.

    Feel free to surf to my web blog – Healix CBD Oil Reviews, shaboxes.com,

  27. 응답

    For hottest information you have to visit the web
    and on the web I found this site as a best web site for most recent updates.

  28. 응답

    I have read several excellent stuff here. Definitely value bookmarking for revisiting.
    I surprise how much attempt you place to create this kind
    of wonderful informative site.

  29. 응답

    For hottest information you have to visit world wide web
    and on world-wide-web I found this web site as a best website for latest
    updates.

  30. 응답

    I like what you guys tend to be up too. This sort of clever work and coverage!
    Keep up the great works guys I’ve included
    you guys to blogroll.

    Also visit my homepage :: Bodice Boost Ketogenic Blend Review – 154.8.233.237

  31. 응답

    I do not even know how I ended up here, but I thought
    this post was good. I do not know who you are but certainly
    you are going to a famous blogger if you aren’t already 😉 Cheers!

  32. 응답

    Hi there to all, how is the whole thing, I think every one is getting more
    from this site, and your views are pleasant in support of new visitors.

    Here is my page: Keto FX 365 (19wujian.com)

  33. 응답

    I know this web site gives quality based articles
    or reviews and extra data, is there any other
    web site which offers such information in quality?

  34. 응답

    Why people still make use of to read news papers when in this technological
    world the whole thing is accessible on web?

  35. 응답

    Hmm it looks like your blog ate my first comment (it was
    super long) so I guess I’ll just sum it up what I submitted and say, I’m
    thoroughly enjoying your blog. I as well am an aspiring blog writer
    but I’m still new to the whole thing. Do you have any tips and hints for beginner blog writers?
    I’d certainly appreciate it.

    my homepage: Sophria Skin Cream (discuz.e70w.com)

  36. 응답

    scoliosis
    I am not sure where you are getting your info, but great topic.
    I needs to spend some time learning much more or understanding more.
    Thanks for fantastic info I was looking for this information for my mission. scoliosis

  37. 응답

    scoliosis
    Excellent goods from you, man. I’ve bear in mind your stuff previous to and you’re simply extremely wonderful.
    I actually like what you have obtained right here, really like what you’re
    saying and the way wherein you assert it. You’re making it enjoyable and you still take care of to
    keep it smart. I cant wait to learn far more from you.
    That is really a tremendous site. scoliosis

  38. 응답

    Hi would you mind stating which blog platform you’re
    working with? I’m planning to start my own blog in the near future but I’m having a difficult time making a decision between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your layout seems different then most
    blogs and I’m looking for something unique.
    P.S My apologies for being off-topic but I had to ask!

  39. 응답

    I blog quite often and I seriously thank
    you for your content. This article has really peaked my interest.
    I will bookmark your blog and keep checking for new information about once a week.

    I subscribed to your Feed too.

  40. 응답

    you’re really a good webmaster. The website loading
    speed is incredible. It seems that you are doing any distinctive trick.
    In addition, The contents are masterpiece. you’ve performed a magnificent process on this topic!

  41. 응답

    I truly love your blog.. Pleasant colors & theme.
    Did you build this site yourself? Please reply back as I’m wanting to create my very own blog and would
    like to find out where you got this from or what the theme is called.
    Thank you!

  42. 응답

    Thanks for any other wonderful post. Where else could anybody get that type of info in such an ideal
    means of writing? I’ve a presentation next week,
    and I’m at the look for such information.

  43. 응답

    An outstanding share! I have just forwarded this onto a coworker who had been conducting a little homework on this.
    And he in fact bought me dinner due to the fact that I found it for him…
    lol. So allow me to reword this…. Thanks for the
    meal!! But yeah, thanks for spending the time to discuss this matter here
    on your web site.

  44. 응답

    I like what you guys are up too. This kind of
    clever work and coverage! Keep up the wonderful works
    guys I’ve included you guys to my personal blogroll.

  45. 응답

    Thanks for some other great article. Where else could anybody get that type of information in such a perfect means of writing?
    I have a presentation subsequent week, and I’m on the search
    for such information.

    Here is my blog … Rhino Storm Review

  46. 응답

    Sweet blog! I found it while searching on Yahoo
    News. Do you have any suggestions on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get there!
    Thanks

  47. 응답

    Thank you for the auspicious writeup. It in fact was a amusement account it.
    Look advanced to more added agreeable from you! By the way, how could we communicate?

  48. 응답

    I have read several just right stuff here.
    Certainly price bookmarking for revisiting.
    I surprise how so much effort you put to create such a fantastic
    informative website.

  49. 응답

    Have you ever considered about adding a little bit more than just your articles?
    I mean, what you say is fundamental and everything.

    But think about if you added some great visuals or video clips to
    give your posts more, “pop”! Your content is excellent but with images
    and video clips, this site could definitely be one of the most beneficial in its niche.

    Great blog!

  50. 응답

    Valuable information. Fortunate me I discovered
    your website unintentionally, and I’m surprised why this accident didn’t happened earlier!
    I bookmarked it.

  51. 응답

    Wonderful work! That is the kind of info that are supposed
    to be shared across the internet. Disgrace on the search engines for no
    longer positioning this post higher! Come
    on over and visit my site . Thanks =)

  52. 응답

    If you would like to grow your familiarity just keep visiting this website and be updated with the most up-to-date news
    posted here.

  53. 응답

    Howdy! This is my first visit to your blog! We are a collection of
    volunteers and starting a new initiative in a community in the same niche.
    Your blog provided us beneficial information to work on. You have done a marvellous job!

  54. 응답

    What’s up it’s me, I am also visiting this web page on a regular basis, this site is actually pleasant
    and the viewers are genuinely sharing good thoughts.

  55. 응답

    After looking over a number of the blog articles on your website,
    I really appreciate your way of blogging. I book marked it
    to my bookmark site list and will be checking back in the near future.
    Take a look at my web site as well and let me know your opinion.

  56. 응답

    Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates.

    I’ve been looking for a plug-in like this for quite some time and
    was hoping maybe you would have some experience with something like this.
    Please let me know if you run into anything. I truly enjoy
    reading your blog and I look forward to your new updates.

  57. 응답

    A person essentially help to make severely posts I might
    state. This is the first time I frequented your web page
    and so far? I amazed with the research you made to make this actual post extraordinary.
    Magnificent job!

  58. 응답

    Oh my goodness! Incredible article dude! Thanks, However I am having problems with
    your RSS. I don’t know the reason why I cannot join it.

    Is there anyone else having the same RSS issues?
    Anybody who knows the solution will you kindly respond?

    Thanks!!

  59. 응답

    Yesterday, while I was at work, my cousin stole my iPad and tested to see if it can survive a twenty five foot
    drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views.
    I know this is completely off topic but I had to share it
    with someone!

  60. 응답

    Do you mind if I quote a few of your articles as long as I provide credit and sources back to your webpage?
    My blog is in the exact same area of interest as yours
    and my visitors would really benefit from some of the information you
    present here. Please let me know if this okay with you.
    Cheers! cheap flights http://1704milesapart.tumblr.com/ cheap flights

Leave a comment

이메일 주소는 공개되지 않습니다.