DiigIT | IT Community
No Profile Image
Welcome Guest
New User? Register | Login
SQL
IT Tags

Simple SQL SELECT Statement

By: rekha singh | 29 Apr 2010 11:08 am

 SQL SELECT Statement

 
The SELECT statement is used to select data (THROUGH WHICH WE CAN GET DETAIL) from a database.
 
The result is stored in a result table, called the result-set.
 
SQL SELECT Syntax
 
    * SELECT column_name(s) FROM table_name
 
    * SELECT * FROM table_name
 
    * select * From table_name where condition
 
Example
 
    * SELECT id,password FROM logintable
 
    * SELECT id FROM logintable WHERE password="maya";

 

Comments

No Comments Posted for this Article.

Leave a comment

Enter the text in the image
img
Can't read?
Type the characters you see in the picture below.


Close Move