基本的sql語句技巧介紹

歡迎大家在這裡學習基本的sql語句技巧!下面是我們給大家整理出來的精彩內容。希望大家在這裡學習!

插入：insert into table1(field1,field2) values(value1,value2)

刪除：delete from table1 where 范圍

更新：update table1 set field1=value1 where 范圍

查找：select * from table1 where field1 like ’%value1%’ ---like的語法很精妙，查資料!

排序：select * from table1 order by field1,field2 [desc]

總數：select count as totalcount from table1

求和：select sum(field1) as sumvalue from table1

平均：select avg(field1) as avgvalue from table1

最大：select max(field1) as maxvalue from table1

最小：select min(field1) as minvalue from table1

基本的sql語句技巧精彩內容就到這裡了!希望大家可以好好利用!

相關推薦：

sqlLIKE語句查詢技巧介紹