Returning a Single Column.sql
SQL>
SQL> CREATE TABLE emp (
2 empID INT NOT NULL PRIMARY KEY,
3 Name VARCHAR(50) NOT NULL);
Table created.
SQL> INSERT INTO emp (empID,Name) VALUES (1,'Victor');
1 row created.
SQL> INSERT INTO emp (empID,Name) VALUES (2,'Bill');
1 row created.
SQL> INSERT INTO emp (empID,Name) VALUES (3,'Mary');
1 row created.
SQL> INSERT INTO emp (empID,Name) VALUES (4,'Jack');
1 row created.
SQL> INSERT INTO emp (empID,Name) VALUES (5,'Peter');
1 row created.
SQL> INSERT INTO emp (empID,Name) VALUES (6,'Tom');
1 row created.
SQL>
SQL>
SQL> SELECT Name FROM emp;
NAME
--------------------------------------------------
Victor
Bill
Mary
Jack
Peter
Tom
6 rows selected.
SQL>
SQL> drop table emp;
Table dropped.
Related examples in the same category