Select command is use to select data from the tables located in a database.If we need to SELECT information FROM a table.

The most basic SQL structure:

A D V E R T I S E M E N T

SELECT "column_name" FROM "table_name"

To illustrate the above example, assume that we have the following table Name "Store_Information" :

store_name	Sales	Date
Los Angeles	$1500	Jan-05-2005
San Diego	$250	Jan-07-2005
Los Angeles	$300	Jan-08-2005
Boston	$700	Jan-08-2005

To select all the stores in this table

SELECT store_name FROM Store_Information

Output

Store_name

Los Angeles
San Diego
Los Angeles
Boston

Distinct Keyword:

The SELECT keyword allows us to take all information from a column (or columns) on a table. Of course, there is probability of redundancies. What if we only want to select each DISTINCT element? This is easy to accomplish in SQL. All we need to do is to add DISTINCT after SELECT. The syntax is as follows:

SELECT DISTINCT "column_name" FROM "table_name"

For example, to select all distinct stores in Table "Store_Information".

SELECT DISTINCT store_name FROM Store_Information

Output

Store_name

Los Angeles
San Diego
Boston

Be the first one to comment on this page.

SQL Tutorial eBooks
No eBooks on SQL could be found as of now.

SQL Tutorial FAQs

More Links » »

SQL Tutorial Interview Questions

What are the five imp fields to be maintained in account determination

What is the basic qualification for SAP Implementation ?

Why u can call(r using) ssf_function_module_name in smartforms?

What we normally check for in the Database Testing?

What is the difference between ATP check and availability check how these reflect in sales order(which check system considers) what are the IMG settings for the same.

What is availability check, how to configure it?

Why u can call(r using) ssf_function_module_name in smartforms?

We get a report screen: "Goods issue: Problem Log" during the delivery process when activating Post Goods Issue button. We want to include our own error message to this list if the selected batch is not on a customer defined table. What is the best way?

Why u can call(r using) ssf_function_module_name in smartforms?

In scripts how to upload logo (it's saved in .bmp file ) What is the procedure?

More Links » »

SQL Tutorial Articles

More Links » »

SQL Tutorial News
Hiring goes 2 steps forward
More Links » »

SQL Tutorial Jobs

More Links » »

Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.

Keywords sql select statement clause, sql statement, sql select statement result set, sql select statement values

HTML Quizzes

XML Quizzes

Browser Scripting Quizzes

Server Scripting Quizzes

.NET (dotnet) Quizzes

Multimedia Quizzes

Gnuplot Programming Quiz

GIF Animation Quiz

Scientific Visualization Quiz

Web Building Quizzes

Web Site Hosting Quiz

Java Quizzes

Programming Langauges Quizzes

C Quiz

C++ Quiz

Visual Basic Quiz

Data Structures Using C Quiz

Cobol Quiz

Assembly Language Quiz

Mainframe Quiz

Forth Programming Quiz

Lisp Programming Quiz

Data Warehousing Quiz

Soft Skills Quizzes

Communication Skills Quiz

Time Management Quiz

Project Management Quiz

Team Work Quiz

Leadership Skills Quiz

Corporate Communication Quiz

Negotiation Skills Quiz

Database Quizzes

Oracle Quiz

MySQL Quiz

Operating System Quizzes

Software Testing Quizzes

SAP Module Quizzes

Business Warehousing Quiz

SAP Basis Quiz

Material Management Quiz

Sales & Distribution Quiz

Human Resource Quiz

Netweaver Quiz

Customer Relationship Management Quiz

Production and Planning Quiz

Networking Programming Quizzes

Corba Quiz

Networking Quiz

Microsoft Office Quizzes

Microsoft Word Quiz

Microsoft Outlook Quiz

Microsoft PowerPoint Quiz

Microsoft Publisher Quiz

Microsoft Excel Quiz

Microsoft Front Page Quiz

Microsoft InfoPath Quiz

Microsoft Access Quiz

Accounting Quizzes

Financial Accounting Quiz

Managerial Accounting Quiz

Testimonials \| Contact Us \| Link to Us \| Site Map
Copyright ? 2008. Academic Tutorials.com. All rights reserved	Privacy Policies \| About Us
Our Portals : Academic Tutorials \| Best eBooksworld \| Beyond Stats \| City Details \| Interview Questions \| Discussions World \| Excellent Mobiles \| Free Bangalore \| Give Me The Code \| Gog Logo \| Indian Free Ads \| Jobs Assist \| New Interview Questions \| One Stop FAQs \| One Stop GATE \| One Stop GRE \| One Stop IAS \| One Stop MBA \| One Stop SAP \| One Stop Testing \| Webhosting in India \| Dedicated Server in India \| Sirf Dosti \| Source Codes World \| Tasty Food \| Tech Archive \| Testing Interview Questions \| Tests World \| The Galz \| Top Masala \| Vyom \| Vyom eBooks \| Vyom International \| Vyom Links \| Vyoms \| Vyom World \| Important Websites
Copyright ? 2003-2024 Vyom Technosoft Pvt. Ltd., All Rights Reserved.

Testimonials \| Contact Us \| Link to Us \| Site Map
Copyright ? 2008. Academic Tutorials.com. All rights reserved	Privacy Policies \| About Us
Our Portals : Academic Tutorials \| Best eBooksworld \| Beyond Stats \| City Details \| Interview Questions \| Discussions World \| Excellent Mobiles \| Free Bangalore \| Give Me The Code \| Gog Logo \| Indian Free Ads \| Jobs Assist \| New Interview Questions \| One Stop FAQs \| One Stop GATE \| One Stop GRE \| One Stop IAS \| One Stop MBA \| One Stop SAP \| One Stop Testing \| Webhosting in India \| Dedicated Server in India \| Sirf Dosti \| Source Codes World \| Tasty Food \| Tech Archive \| Testing Interview Questions \| Tests World \| The Galz \| Top Masala \| Vyom \| Vyom eBooks \| Vyom International \| Vyom Links \| Vyoms \| Vyom World \| Important Websites
Copyright ? 2003-2024 Vyom Technosoft Pvt. Ltd., All Rights Reserved.

SQL Select Statement

Select Command

No eBooks on SQL could be found as of now.