visit this website to learn sql query http://www.w3schools.com/sql/default.asp
and for java website pls visit http://www.jaypeeworldprogrammer.blogspot.com/
i hope you learn and be a problem solver
Thursday, July 29, 2010
Select Statement in SQL
Select Statement - used to select data from a database.
syntax:
to select all record in database.
Select * from tableName
to select column in the database.
Select Column1, Column2, Column3......
from tableName
syntax:
to select all record in database.
Select * from tableName
to select column in the database.
Select Column1, Column2, Column3......
from tableName
SQL - structured query language
What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL is an ANSI (American National Standards Institute) standard
What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can set permissions on tables, procedures, and views
Subscribe to:
Posts (Atom)