Describe the elements of the SELECT query syntax?

Question Posted / guest

3 Answers
6620 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Describe the elements of the SELECT query syntax?..

Answer / gopinath

select <column name(s)>,<column name(s)> from <table name>
where <column name> <condition>

Is This Answer Correct ?

2 Yes

0 No

Describe the elements of the SELECT query syntax?..

Answer / sunil1405

SELECT * FROM <TABLE NAME> WHERE COLNAME=<PARAMETERS>;

Is This Answer Correct ?

1 Yes

0 No

Describe the elements of the SELECT query syntax?..

Answer / guest

The select command is used SELECT the data from the
database.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB2 Interview Questions

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers IBM,

What is ibm db2 connect?

0 Answers

what is SPUFI ?

2 Answers

Compare a subselect to a join?

1 Answers

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers IBM,

What are iseries servers?

0 Answers

What is the maximum number of columns in a db2 table?

0 Answers IBM,

How are write I/Os from the buffer pool executed?

1 Answers

what is the sqlcode -501

5 Answers IBM, Polaris, Zeus,

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers

For more DB2 Interview Questions Click Here