Monday, 20 July 2015

WHAT IS DIFFERENCE BETWEEN WHERE CLAUSE AND HAVING CLAUSE ?

WHERE                                                                                                                 HAVING
=================================               ================================
1. WHERE CLAUSE RESTRICT THE ROWS        1.HAVING CLAUSE RESTRICT THE ROWS
RETURNED BY THE SINGLE ROW FUNCT           RETURNED BY THE GROUP FUNCTIONS.
TIONS.

2.WHERE CLAUSE SHOULD APPEAR                 2.HAVING CLAUSE SHOULD APPEAR
BEFORE GROUP BY CLAUSE.                                  AFTER GROUP BY CLAUSE.

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...