SQL QUERY CHALLENGE – TEST YOUR DBMS KNOWLEDGE

━━━━━━━━━━━━━━━━━━━━━━

Consider the following table:

Students

| ID | Name | Marks |
|---|---|---:|
| 1 | Rahul | 75 |
| 2 | Priya | 90 |
| 3 | Amit | 60 |
| 4 | Neha | 85 |
| 5 | Karan | 95 |

Question:

Which SQL query will display students who scored more than 80 marks?

A.

SELECT * FROM Students
WHERE Marks < 80;

B.

SELECT * FROM Students
WHERE Marks > 80;

C.

SELECT Name FROM Students;

D.

SELECT * FROM Students
ORDER BY Marks;

━━━━━━━━━━━━━━━━━━━━━━

Comment your answer: A, B, C or D.

Correct answer and explanation in the next SQL challenge!

UPDATEGADH | Technology Tutorials and Projects

#SQL #SQLChallenge #DBMS #BCAStudents #MCAStudents #CodingChallenge #UPDATEGADH