Computer Science · Database Management Systems
एक रिटेल कंपनी दो टेबल बनाए रखती है: Customers(CustID, CustName) और Orders(OrderID, CustID, OrderAmount)। वे प्रत्येक ग्राहक के कुल खर्च को देखना चाहते हैं। कौन सा SQL कथन इसे सबसे अच्छी तरह प्राप्त करता है?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1SELECT * FROM Customers, Orders WHERE OrderAmount > 0;
- 2SELECT CustName, OrderAmount FROM Customers NATURAL JOIN Orders;
- 3SELECT CustName, SUM(OrderAmount) FROM Customers JOIN Orders ON Customers.CustID = Orders.CustID GROUP BY CustName;✓
- 4SELECT CustName, SUM(OrderAmount) FROM Orders;
सही उत्तर देखें
SELECT CustName, SUM(OrderAmount) FROM Customers JOIN Orders ON Customers.CustID = Orders.CustID GROUP BY CustName;
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 Database Management Systems MCQs →Want more practice questions on Database Management Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management Systems