oracle查询语句

 

1)
SELECT * FROM  EDOODS207 WHERE EDOODS207.G_NAME LIKE '%三星%';
2
SELECT * FROM  EDOODS207 WHERE G_NAME LIKE '%三星%'and  g_status LIKE '热点';
3）
SELECT * FROM  EDOODS207 WHERE g_status LIKE '热点'or g_price BETWEEN 2000 and 4500;
4）
select g_id from EDOODS207 group by g_id having sum(g_price* g_number)>6000 ORDER by sum(g_price* g_number) desc;
5）
SELECT * FROM  EDOODS207 WHERE g_number IN(20,15);
6）
UPDATE  EDOODS207 SET  g_PRICE= g_price+10 WHERE  t_id='01';
7）
SELECT * FROM