Describe the elements of the SELECT query syntax?

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 is the use of db2?

588


What is alias in db2?

572


What is the use of runstats in db2?

579


Is ibm db2 free?

577


How would the varchar column remarks defined?

639






What is null indicator in cobol db2?

587


What are the uses of db2 optimizer?

819


How would you find out the total number of rows in a db2 table?

579


What is role in db2?

622


How to access db2 tables in mainframe?

615


What is dbrm library?

579


What is null indicator in db2?

605


What is a system catalog table in db2?

590


What is the use of value function?

629


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1238