Welcome guys..

This is programmer sharing his collection with all you ppl out there. This blog contains complete codes of java , c , c++ , unix , java script , applets , swing for learning purpose only. I try to add approx 10 new complete codes daily. Lets share out knowledge and materials in here. All your comments and votes are most welcomed.

Get your codes from..

Saturday, May 10, 2008

Most Commonly used SQL statements

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

No comments:

Project Source Codes