Which of the following is true about the HAVING clause ?
हैविंग क्लॉज के बारे में निम्नलिखित में से कौन - सा कथन सत्य है ?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. Similar to WHERE clause but is used for groups rather than rows.वेयर क्लॉज के समान लेकिन यह रो के बजाय समूहों के लिए उपयोग किया जाता है।
Explanation
HAVING works like WHERE but filters groups (after GROUP BY); WHERE filters rows.
HAVING, WHERE जैसा है पर GROUP BY के बाद समूहों को फ़िल्टर करता है; WHERE पंक्तियों को।
More Database Management & SQL questions
- Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation ?
- Which of the following is not a DDL command ?
- The command center of MS-Access file that appears when you create or open the MS-Access database file, is called :
- A functional dependency is a relationship between or among :
- Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify t…
- If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be :