1.) simple select statements:
select * from
select * from where =''
select * from where ='' order by
select * from where like '%%'
2.) select statements that will model your data:
select count(*) from where like '%%'
select sum() total_ from
select sum() total_, sum() total_ from
select avg() ave_number_of_ from
select avg()/avg() overall_average from
select max() from
2.a) variance and standard dviation
select variance() from
select stddev() from
2.b) arithmetic functions
select abs() absolute_value from
select , ceil() ceiling from
3.) table joins
select * from ,
select t., t., tw., tw. from t, tw
select t., t., tw., tw. from t, tw where t. = tw.
select t., t., tw., tw. from t, tw where t. > tw.
4.) sub query
select * from where = (select from where like '%%')
select * from where like (select from where <= '%%')
5.) exists
select * from where exists (select * from where = '')
6.) insert, update, delete
insert into (, ) values('',)
insert into select * from
update set = , =
delete from where <
7.) table creatation, alter table, drop table
create table ( char(20), int(30))
alter table modify char(40)
drop table
Get your codes from..
Saturday, May 10, 2008
Most Commonly used SQL statements
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment