前提 table , b
table a 中有字段 c, d,e
table b 中有字段 f, h
1) select * from a where a.c=10 and a.d='aa' and a.e in (select b.f from b )
2) select distinct (a.c), count(*) from a group by a.c
这个语句是说筛选出a表中c字段唯一的数值,并对该字段做统计
3)select distinct(a.c),count(*) from tt_sales_order t where t.d=8899 group by t.model_code;
where 语句和group by 一起使用
4)select * from a for update(执行该语句后把数据表左上的小钥匙打开)就可编辑了
5)update a set a.c=6,a.d=a;
6)select * from a,b where a.c=b.f;
7)select distinct(a.c),count(*) from tt_sales_order td group by a.c order by count(*)
8)配置设置:
C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
:tnsnames.ora
设置如下:
OMD1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.122.51.124)(PORT =1521))
)
(CONNECT_DATA =
(SERVICE_NAME =SVW)
)
)
9)Eclips-SVW
10)删除表中的记录
delete a a where a.c='101001s';
delete tt_sales_order too where too.sales_order_code='2010A001375951';