Ò»ÌõSQLÓï¾ä

SQL code:


SQL> select * from student;

NAME AGE
---------- ----------
a 18
b 18
c 18
d 19
e 19
f 19
g 18
h 18
i 18

ÒÑÑ¡Ôñ9ÐС£

SQL> break on age;
SQL> select * from student;

NAME AGE
---------- ----------
a 18
b
c
d 19
e
f
g 18
h
i

ÒÑÑ¡Ôñ9ÐС£

SQL> select * from student where age = 18;

NAME AGE
---------- ----------
a 18
g 18


ÒÑÑ¡Ôñ2ÐС£
ÈçºÎʵÏÖ£¿

--µ«ÎÒÏÖÔÚÏëÒªµÄ½á¹ûÊÇ£º

SQL> select * from student where age = 18;

NAME AGE
---------- ----------
a 18
b
c
g
h
i

---

ÒýÓÃ

SQL code

SQL>select*from student;

NAME              AGE---------- ----------a18
b18
c18
d19
e19
f19
g18
h18
i18

ÒÑÑ¡Ôñ9ÐС£

SQL>breakon age;
SQL>select*from student;

NAME              AGE---------- --?-

˵·´ÁË£¬
ÏÖÔÚÊÇ
S