SELECT * FROM tb_name WHERE sum > 100;

 SELECT * FROM tb_stu WHERE sname = '小刘'
 SELECT * FROM tb_stu WHERE sname like '刘%'
 SELECT * FROM tb_stu WHERE sname like '%程序员'
 SELECT * FROM tb_stu WHERE sname like '%PHP%'

SELECT * FROM tb_stu WHERE date = '2011-04-08'

 (1)MySQL:SELECT * from tb_name WHERE birthday = '2011-04-08'

(2)SQL Server:SELECT * from tb_name WHERE birthday = '2011-04-08'


 (3)Access:SELECT * from tb_name WHERE birthday = #2011-04-08#

 SELECT * FROM tb_name WHERE type = 'T'
 SELECT * FROM tb_name WHERE type = 'F'

 SELECT * FROM tb_name WHERE address <>'' order by addtime desc

SELECT * FROM tb_name WHERE id = '$_POST[text]' 

SELECT * FROM tb_name WHERE name LIKE '%$_POST[name]%' 

SELECT * FROM tb_name LIMIT 0,$N;

SELECT * FROM tb_stu ORDER BY id ASC LIMIT $n

 SELECT * FROM tb_stu ORDER BY id ASC LIMIT $_POST[begin],$n

SELECT * ,(yw+sx+wy) AS total FROM tb_score ORDER BY (yw+sx+wy) DESC LIMIT 0,$num 

SELECT * FROM tb_stu WHERE age BETWEEN 0 AND 18

SELECT * FROM tb_stu WHERE month(date) = '$_POST[date]' ORDER BY date ;

SELECT * FROM tb_stu WHERE age>$_POST[age] ORDER BY age;

 SELECT name,age,count(*) ,age FROM tb_stu WHERE age = '19' group by date

SELECT name,SUM(price) AS sumprice FROM tb_price GROUP BY name 


SELECT * FROM tb_name ORDER BY mount DESC,price ASC 

 SELECT id,name,SUM(price) AS title,date FROM tb_price GROUP BY pid ORDER BY title DESC

 SELECT id,name,SUM(price*num) AS sumprice FROM tb_price GROUP BY pid ORDER BY sumprice DESC

 SELECT a.name,AVG(a.price),b.name,AVG(b.price) FROM tb_demo058 AS a,tb_demo058_1 AS b WHERE a.id=b.id GROUP BY b.type;