PrepSnap logoPrepSnap
Pass

Question

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

Option 1 : SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC / SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC

Advertisement

Detailed Solution

सही उत्तर SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC / SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Table Students has columns RollNo, Name, Class, Marks. Which query returns the names of Class 10 students scoring above 75, sorted by marks in descending order? / तालिका Students में स्तंभ RollNo, Name, Class, Marks हैं। कौन-सी क्वेरी 75 से अधिक अंक वाले कक्षा 10 के छात्रों के नाम अंक के घटते क्रम में देगी?

1.
SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC / SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC
2.
SELECT Name FROM Students ORDER BY Marks DESC WHERE Class = 10 AND Marks > 75 / SELECT Name FROM Students ORDER BY Marks DESC WHERE Class = 10 AND Marks > 75
3.
SELECT Name FROM Students WHERE Class = 10 OR Marks > 75 ORDER BY Marks / SELECT Name FROM Students WHERE Class = 10 OR Marks > 75 ORDER BY Marks
4.
SELECT Name FROM Students WHERE Marks > 75 GROUP BY Name ORDER BY Marks DESC / SELECT Name FROM Students WHERE Marks > 75 GROUP BY Name ORDER BY Marks DESC

Correct Answer: SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC / SELECT Name FROM Students WHERE Class = 10 AND Marks > 75 ORDER BY Marks DESC

Filtering needs WHERE before ORDER BY with AND combining both conditions; ORDER BY cannot precede WHERE, OR widens wrongly, and GROUP BY is meaningless without aggregation. / छनन हेतु WHERE, ORDER BY से पहले चाहिए और दोनों शर्तों को AND जोड़े; ORDER BY, WHERE से पहले नहीं आ सकता, OR गलत फैलाता है, और समुच्चयन बिना GROUP BY निरर्थक है।

Downloaded from PrepSnap (prepsnap.in)