Thats it.Code:SQL> create table emp (ename varchar2(50), esex varchar2(10)); Table created. SQL> insert into emp select object_name,'Male' from dba_objects; 9369 rows created. SQL> commit; Commit complete. SQL> insert into emp select object_name,'Female' from dba_objects where rownum < 20; 19 rows created. SQL> commit; Commit complete. SQL> select esex,count(*) from emp 2 group by esex; ESEX COUNT(*) ---------- ---------- Female 19 Male 9369




Reply With Quote