Describe the elements of the SELECT query syntax?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ibm db2 connect?

585


Explain in detail about buffer manager and its functionalities?

576


Explain various types of locks in db2?

707


What is load replace in db2?

566


What is the clustering index in the db2 database?

592






What is dbrm? When it will be created?

608


What is the default page size of buffer pools?

658


What is the use of db2?

599


What are host variables in db2?

635


How does cobol compile db2 program?

619


If I have a view which is a join of two or more tables, can this view be updateable?

704


What is runstats utility in db2?

584


Can one database have multiple instances?

587


What is dbrm? What it contains? When it will be created?

599


Mention the various locks that are available in db2.

622