Describe the elements of the SELECT query syntax?

COBOL SQL Interview Questions

(Continued from previous question...)

Describe the elements of the SELECT query syntax?

SELECT element FROM table WHERE conditional statement.

(Continued on next question...)

Other Interview Questions

• What is the difference between static and dynamic SQL?
• What is meant by an index?
• How do you select a row using indexes?
• Is BETWEEN inclusive of the range values specified?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• What do you accomplish by GROUP BY ... HAVING clause ?
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• Describe the elements of the SELECT query syntax?
• What is the use of VALUE function?
• Where in a table are added column located ?
• More...