Create Table, Insert Records into tables

create table emp ( name varchar2(20));

insert into emp (name) values ('&name');

select * from emp

select * from emp order by name

select * from emp group by name

12 FEB 2015 UPDATE

select * from employees

select * from employees order by first_name

IT WON'T WORK

The following query works without error

select salary from employees group by salary

Pages