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

Describe the elements of the SELECT query syntax?

Question Posted / sunil1405

Answer Posted / sunil1405

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is db2 free?

1035

What is bind package and plan in db2?

1004

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2864

what are bind concepts in db2 cobol?

1033

What is bufferpool in db2?

983

Can we insert update delete in view?

908

What is query_cache_limit?

927

What is check constraint in db2?

1011

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1001

How to find the maximum value in a column in the db2 database?

1013

How to restart a DB2 program?

1824

What is meant by explain?

1059

List out the buffer pools in db2

1018

What are the various data types available in db2?

1011

What is the use of commit in db2?

1000