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

Describe the elements of the SELECT query syntax?

Question Posted / gopinath

Answer Posted / gopinath

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is syscat in db2?

963

What is cloudant database?

1054

How do I add a column in db2?

1011

What's The Error Code For Unique Index Voilation?

1176

Is db2 relational database?

935

How many databases can be created inside an instance in db2 ?

994

What is the use of db2 optimizer?

1067

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1024

How do I delete a table in database?

994

How do I change the column size in db2?

1107

What is concurrency?

1168

How do we specify index to include or not during bind process.

2088

How can you do the explain of a dynamic sql statement?

1040

What is the purpose of using commit?

1052

How can the duplicate values be eliminated from db2 select?

1058