What are some SQL aggregates and other built-in functions?

COBOL SQL Interview Questions

(Continued from previous question...)

What are some SQL aggregates and other built-in functions?

The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.

(Continued on next question...)

Other Interview Questions

• How would you find out the total number of row in a table?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• We have a table with a CHARACTER data type field
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• What is meant by locking?
• What is a subselect? It is different from a nested select ?
• When can an insert of a new primary key value threaten referntial integrity?
• How is the SUBSTR keyword used in SQL?
• How do you specify and use a cursor in a COBOL program?
• What are the wildcard characters ?
• More...