求一个sql语句。

Question

可以,
不过要根据情况来写sql语句

Answer 1

SQL> select * from test3;        ID DOCTIME            P1 NEWZYZ
---------- ---------- ---------- ----------
        25 01-7月 -01            2002-01-01
        26 01-7月 -01            1999-01-01
        41 01-7月 -01            2000-01-01
         6 01-7月 -01            2002-01-01
        22 01-7月 -01            2001-01-01SQL> desc test3;
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------------------- ID                                        NOT NULL NUMBER
 DOCTIME                                   NOT NULL DATE
 P1                                                 NUMBER
 NEWZYZ                                             VARCHAR2(10)SQL> select substr(newzyz,1,4), sum(id) from test3 where substr(newzyz,1,4)>=199
8 and substr(newzyz,1,4)<=2002 group by substr(newzyz,1,4);SUBSTR(N    SUM(ID)
-------- ----------
1999             26
2000             41
2001             22
2002             31

Answer 2

SELECT SUM(FIELD_NAME) GROUP BY SUBSTR(时间, 1, 4)