Home SQL Basic Select
09.09.2010
Main Menu
Programming
.NET Controls
Operating System
Databases
Articles
Add to: Digg Add to: Del.icoi.us Add to: Reddit Add to: StumbleUpon Add to: Slashdot Add to: Yahoo Add to: Technorati Add to: Google
Select

 The select command is use to retrieve data from the database. The statement comprise of two keywords:

  • SELECT
The SELECT clause choose which columns to be display in the result
  • FROM
The FROM clause specify which database table to retrieve the information from.

SELECT "column_name" FROM "table_name"

EXAMPLES:

Table: Student

StudentID LastName FirstName DOB
1 John Astone 15/07/1976
2 Bob Eastwood 13/02/1935
3 Jane Hollywood 23/03/1939

 SELECT LastName FROM Student;

Result:

LastName

John
Bob
Jane




Comments (0)
Write comment
Your Contact Details:
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."