What is the difference between group by and order by ?

COBOL SQL Interview Questions

(Continued from previous question...)

What is the difference between group by and order by ?

Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement.

(Continued on next question...)

Other Interview Questions

• What is a cursor? Why should it be used ?
• What is a correlation name?
• What RDMS objects are crested with the SQL CREATE statements?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• Any SQL implementation covers data types in couple of main categories. Which of the following are those data types?
• What is an alias and how does it differ from a synonym?
• What are the column name qualifiers?
• What are foreign keys?
• Describe the elements of the SELECT query syntax?
• Describe the elements of the SELECT query syntax?
• More...