阅读背景:

任何人都可以告诉我如何根据生成的输出在此查询中发生记录流

来源:互联网 
SQL> select * from employee;

ID   FIRST_NAME LAST_NAME  START_DAT END_DATE      SALARY CITY       DESCRIPTION
---- ---------- ---------- --------- --------- ---------- ---------- ---------------
03   Jason      Martin     25-JUL-96 25-JUL-06    1234.56 Toronto    Programmer
03   Alison     Mathews    21-MAR-76 21-FEB-86   13323.56 Vancouver  Tester
04   James      Smith      12-DEC-78 15-MAR-90   52358.24 Vancouver  Tester
05   Celia      Rice       24-OCT-82 21-APR-99    2344.78 Vancouver  Manager
03   Linda      Green      30-JUL-87 04-JAN-96    4322.78 New York   Tester
03   David      Larry      31-DEC-90 12-FEB-98    7897.78 New York   Manager

6 rows selected.

SQL> select id,first_name
  2  from employee
  3  group by id, first_name;

ID   FIRST_NAME
---- ----------
03   Linda
03   Jason
04   James
05   Celia
03   David
03   Alison
SQL> select * from employee;

ID   FIRST_NAME L



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: