Monday, April 18, 2016

SQL : Selecting Specific Columns

Selecting Specific Columns

Specific columns can be selected by using SQL select statement.

Example:
select department_id, department_name from departments;

In the above example , out of all the columns in a table departments only department_id,department_name  are selected.


Columns are show in the order they are selected. 

An Example below:

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts