ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software

SQL Select Statement

Updated on December 4, 2012

The SQL Select Statement is the most commonly used, and perhaps, one of the very first SQL commands one should learn to use.

Rather than start off with explanations and definitions, I'm jumping right in with the creation of a very simple table, and then giving you several examples of SQL Select commands and the results provided.

In essence, I'm going to show you specific "SELECT" examples first, and then follow up with some brief syntax commonly used.

By showing you the simple table structure, I'm hoping that will help you clearly understand the SQL "Select" statement commands and query results.

NOTE - In this article, I'll be using Microsoft's SSMS (SQL Server Management Studio) 2008R2

Grab that energy drink and let's get started!

Creating a Very Simple SQL Table

In my hub "How to Back up a SQL 2005 Database", I created a database named "Howlermunkey INC". Now I'll show you how to easily create a very simple table which I will then use to query the "Select" statement against.

  1. First I'll open SSMS and expand my "Howlermunkey INC" database
  2. I'll then right click "Tables" and select "New Table"
  3. I'll name my first column "HUB_NAME", with the data type as "nvarchar(MAX)"
  4. I'll name my second column "DATE_PUB" with the data type as "datetime"
  5. Next I'll save the table as "HUBS"
  6. Then I'll quickly populate my new table "HUBS" by right clicking the table and selecting "Edit Top 200 Rows"
  7. Finally I'll add the Names of my hubs published in the first column, then the date published in the second , TIP - (12/4/12) format works just fine.
  8. Now I'll close that query window and create a "New Query".

Create\ing a simple 2 Column Table
Create\ing a simple 2 Column Table
RIGHT CLICK AND EDIT TOP 200 ROWS
RIGHT CLICK AND EDIT TOP 200 ROWS

SQL Select Statements

~

1. SELECT * from HUBS (shows the entire "hubs" table)

2. SELECT * from HUBS ORDER BY DATE_PUB (shows entire table and sorts by date)

3. SELECT HUB_NAME from HUBS (shows only the column "HUB_NAMES")

~

SELECT * from HUBS (Select ALL from table)
SELECT * from HUBS (Select ALL from table)
Select * from HUBS Order by Date_PUB
Select * from HUBS Order by Date_PUB
SELECT HUB_NAME from HUBS (Select column from table)
SELECT HUB_NAME from HUBS (Select column from table)

SQL SELECT, WHERE, LIKE

`

4. SELECT * from HUBS where Date_Pub > ('2012/11/20') (only hubs published after 11/20)

5. SELECT * from HUBS where HUB_NAME like (%ubuntu%) (Shows any hub with "ubuntu" in "HUB_Name" column)

TIP - You may have noticed I'm using the same SSMS query window, you can highlight the command you need and hit query, you will get results only from the command(s) highlighted

SQL SELECT WHERE, LIKE, AND

`

6. SELECT * from HUBS where HUB_NAME like (%ubuntu%) AND Date_Pub > ('2012/11/11')

SQL SELECT Examples

  • SELECT * FROM Table
  • SELECT * FROM Table ORDER BY expression
  • SELECT * FROM Table LIKE expression AND expression
  • SELECT Column FROM Table Order By order_expression

Have a general Idea? That was my intention! There are plenty of resources available where you can dig deep into SQL Statement syntax. My goal here was to show you a very basic table, with very common "SELECT" queries, giving you very practical results, and helping you learn FAST!


Comments

    0 of 8192 characters used
    Post Comment

    • dwachira profile image

      [ Danson Wachira ] 5 years ago from Nairobi, Kenya

      Hi howlermunkey,

      Ever since i fell in love with SQL during Visual FoxPro programming, i have always liked the queries, simple yet powerful. Once one grab the concept of "SELECT ....WHERE" the other concepts become more understandable. I like how you have done it simple here. Great article, voted up and shared with followers.

    • howlermunkey profile image
      Author

      Jeff Boettner 5 years ago from Tampa, FL

      @jimagain, haha, yup, I'm all about free too. Hit me up if you need version info etc.

    • jimagain profile image

      jimagain 5 years ago from Hattiesburg, Mississippi

      Thanks. I plan on downloading the SQL Epress. I can afford free.

    • howlermunkey profile image
      Author

      Jeff Boettner 5 years ago from Tampa, FL

      @jimagain, glad to hear your response, that was my goal! Excel can do some things similar, but has a worksheet/workbook type layout. Excel is good for certain projects. Access is a simplified version of DB MGMT, but is space limited. For a small project access could suffice. The beauty of SQL is the dynamic abilities (and speed).

      For example, picture hundreds of tables in one db linked together, connected to .net and ported through a web server.

      But sql is actually fun, very useful, and I do recommend spending some time with it if you like what you see. Thanks for stopping by!

      PS -- you can download Microsoft's SQL express for free :)

    • jimagain profile image

      jimagain 5 years ago from Hattiesburg, Mississippi

      Loved this. It seemed simple enough even I can do it. I use Excel a lot. Made me want to get the software so I could use it. Does Excel or Access have similar features?

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://hubpages.com/privacy-policy#gdpr"

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. (Privacy Policy)
    CloudflareThis is used to quickly and efficiently deliver files such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisements has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)