Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.28)

28. 

To define what columns should be displayed in an SQL SELECT statement:

[A]. use FROM to name the source table(s) and list the columns to be shown after SELECT.
[B]. use USING to name the source table(s) and list the columns to be shown after SELECT.
[C]. use SELECT to name the source table(s) and list the columns to be shown after USING.
[D]. use USING to name the source table(s) and list the columns to be shown after WHERE.

Answer: Option A

Explanation:

No answer description available for this question.

Sangeeta said: (Aug 25, 2011)  
Explanation please.

Srilatha said: (Aug 30, 2011)  
Select ename, sal from emp where deptno=10;.

Vinay(Bml) said: (Dec 7, 2011)  
We use select to display the table ?

Ayub said: (Feb 16, 2013)  
We use SELECT to Display the DATA of COLUMN(S) Of Table..
e.g. SELECT COLUMN1,COLUMN2,COLUMN3,.....,COLUMNn from TABLENAME;

OR

SELECT * from TABLENAME;

where * is used to show the data od ALL COLUMNS within a Table.

Sandy said: (Sep 23, 2014)  
Use the following:

SELECT col_1, col_2, . . . , col_n FROM table_name;

Vedanand Singh said: (Dec 9, 2017)  
Explain it.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.