Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Describe the elements of the SELECT query syntax?

Question Posted / guest

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

What happens in bind step in a db2 program?

0 Answers  

Describe the elements of the SELECT query syntax?

3 Answers  

wht displays the number of times a query modified ?

2 Answers   TCS,

How is a typical db2 batch pgm executed?

0 Answers  

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

Can we update view in db2?

0 Answers  

What is db2 and what is the use of db2 optimizer?

0 Answers  

What is a data page?

1 Answers  

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

What is the difference between Primary key and unique index?

6 Answers  

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories