Structured Query Language (SQL) · Class 12 · CBSE · Science Computer Science
A relation named STUDENT has the columns RollNo, Name, and Marks. Write an SQL query to display the Name and Marks of students whose Marks are betwee…
Practice question from Structured Query Language (SQL) (Class 12 · CBSE · Science Computer Science), with the correct answer and a step-by-step solution.
medium · Subjective · Q-61ECF0
A relation named STUDENT has the columns RollNo, Name, and Marks. Write an SQL query to display the Name and Marks of students whose Marks are between 60 and 80 inclusive, arranging the result in descending order of Marks.
Solution
The WHERE clause selects marks from 60 through 80, including both limits. ORDER BY Marks DESC sorts the selected records from the highest marks to the lowest.
More from Structured Query Language (SQL)
- Which SQL query displays each different city name only once from the relation STUDENT?
- A relation named EMPLOYEE has the columns EmpID, Dept, and Salary. Which query displays the departments whose average salary is greater tha…
- Which SQL query correctly adds a column named Email to the STUDENT table?
- A database has CUSTOMER(CustID, Name) and ORDERINFO(OrderID, CustID, Amount). Which query displays the names of customers who have not plac…
Practise more Computer Science
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed