Computer Science · Database Management System
दी गई तालिका 'STUDENT' के आधार पर निम्नलिखित MySQL क्वेरी का आउटपुट ज्ञात कीजिए: तालिका: STUDENT +-----+--------+-----+------+ | SID | SNAME | SEC | MARKS| +-----+--------+-----+------+ | 101 | Ameena | A | 83 | | 107 | Arjun | B | 86 | | 112 | Albert | B | 80 | | 120 | Akram | A | 85 | +-----+--------+-----+------+ क्वेरी: SELECT SEC, AVG(MARKS) FROM STUDENT GROUP BY SEC HAVING MIN(MARKS) > 80;
- 1B 83 A 80
- 2A 84 B 83
- 3A 84✓
- 4B 83
सही उत्तर देखें
A 84
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Database Management System?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management System