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

Describe the elements of the SELECT query syntax?

Question Posted / sunil1405

3 Answers
6614 Views
I also Faced
E-Mail Answers

Answer Posted / sunil1405

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

1170

Explain dclgen.

1268

Outputs of explain are with matchcols = 0. What does this signify?

1108

What is query_cache_limit?

1034

What is the purpose of using commit?

1153

Is db2 a mainframe database?

1046

Explain how can you do the explain of a dynamic sql statement?

1174

What is the function of logging in the db2 database?

1172

What is the difference between using bind () and rebind () methods of naming class?

1454

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372

How to check last update on table in db2?

1097

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3202

What is package in cobol db2?

1159

What is the meaning concurrency in the db2 database?

1161

What are catalog tables in db2?

1105