Computer Science · SQL Queries
निम्नलिखित EMP तालिका पर विचार करें: EMP_NO | SALARY | GRADE E001 | 1000 | E1 E002 | 2000 | E4 E003 | 1500 | E2 E004 | 4000 | E4 ग्रेड 'E4' से संबंधित कर्मचारियों का औसत वेतन प्रदर्शित करने के लिए निम्नलिखित में से कौन सा SQL SELECT कथन निष्पादित किया जाना चाहिए?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1SELECT AVG(SALARY) FROM EMP GROUP BY GRADE HAVING GRADE = 'E4';✓
- 2SELECT AVG(SALARY) FROM EMP GROUP BY GRADE WHERE GRADE = 'E4';
- 3SELECT AVG(SALARY) FROM EMP HAVING GRADE = 'E4';
- 4SELECT AVG(SALARY) FROM EMP WHERE GRADE = 'E4';
सही उत्तर देखें
SELECT AVG(SALARY) FROM EMP GROUP BY GRADE HAVING GRADE = 'E4';
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!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice SQL Queries MCQs →Want more practice questions on SQL Queries?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · SQL Queries