Database - Introduction to SQL - Discussion

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.

Name *:

Email : (optional)

» Your comments will be displayed only after manual approval.

Interview Questions and Answers