PrepSnap logoPrepSnap
Pass

Question

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

Option 1 : East only / केवल East

Advertisement

Detailed Solution

सही उत्तर East only / केवल East है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Table Sales(Region, Amount) holds: North 100, North 200, South 150, South 150, East 300, East 50, West 250. What does SELECT Region FROM Sales GROUP BY Region HAVING SUM(Amount) > 300 ORDER BY Region; return? / तालिका Sales(Region, Amount) में ये मान हैं: North 100, North 200, South 150, South 150, East 300, East 50, West 250। SELECT Region FROM Sales GROUP BY Region HAVING SUM(Amount) > 300 ORDER BY Region; क्या लौटाएगा?

1.
East only / केवल East
2.
East and North / East और North
3.
East, North and South / East, North और South
4.
North and South / North और South

Correct Answer: East only / केवल East

Group totals are North 300, South 300, East 350, West 250. The HAVING clause uses strict greater-than, so the two regions totalling exactly 300 are excluded; only East (350) qualifies. / समूह योग हैं: North 300, South 300, East 350, West 250। HAVING शर्त में सख्त greater-than है, इसलिए ठीक 300 योग वाले दो क्षेत्र बाहर हो जाते हैं; केवल East (350) अर्हता प्राप्त करता है।

Downloaded from PrepSnap (prepsnap.in)