PrepSnap logoPrepSnap
Pass

Question

1.
2.
3.
4.
Answer (Detailed Solution Below)

Option 2 : SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp); / SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp);

Advertisement

Detailed Solution

सही उत्तर SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp); / SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp); है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Which query correctly lists employees earning more than the average salary? / औसत वेतन से अधिक कमाने वाले कर्मचारियों को सूचीबद्ध करने वाली सही क्वेरी कौन-सी है?

1.
SELECT Ename FROM Emp WHERE Salary > AVG(Salary); / SELECT Ename FROM Emp WHERE Salary > AVG(Salary);
2.
SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp); / SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp);
3.
SELECT Ename FROM Emp GROUP BY Ename HAVING Salary > AVG(Salary); / SELECT Ename FROM Emp GROUP BY Ename HAVING Salary > AVG(Salary);
4.
SELECT Ename FROM Emp WHERE Salary > AVG(SELECT Salary FROM Emp); / SELECT Ename FROM Emp WHERE Salary > AVG(SELECT Salary FROM Emp);

Correct Answer: SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp); / SELECT Ename FROM Emp WHERE Salary > (SELECT AVG(Salary) FROM Emp);

Aggregate functions cannot appear in WHERE, so the average must be computed in a subquery; (c) misuses HAVING and (d) is invalid syntax. / समुच्चय फंक्शन WHERE में नहीं आ सकते, अतः औसत सबक्वेरी में निकालना होगा; (c) HAVING का दुरुपयोग है और (d) अमान्य सिंटैक्स है।

Downloaded from PrepSnap (prepsnap.in)