Consider the given table 'Result'. Student Name Marks A 55 B 90

step 1 All right for the first part, students with marks greater than 80 in descending order. The corre

Consider the given table 'Result'. Student Name ...

Consider the given table 'Result'. $$ \begin{array}{cc} \hline \text { Student Name } & \text { Marks } \\ \hline A & 55 \\ B & 90 \\ C & 40 \\ D & 80 \\ E & 85 \\ F & 95 \\ G & 82 \\ \hline \end{array} $$ (i) Find out the students who have scored more than 80 marks, and display them in descending order according to their marks? (A) SELECT student-name,marks FROM Result WHERE marks $>80$ ORDERBY marks DESC (B) SELECT FROM Result WHERE marks $>80$ ORDERBY marks DESC (C) SELECT student-name,marks FROM Result WHERE marks $>80$ ORDERBY marks (D) (A) and (B) (ii) From the above table, find out the top-most three students. (A) SELECT student-name FROM Result ORDERBY marks DESC $>3$ (B) SELECT student-name FROM Result ORDERBY marks DESC $=3$ (C) SELECT student-name FROM Result ORDERBY marks DESC limit 3 (I) None of these

Consider the given table 'Result'.
$$ \begin{array}{cc} \hline \text { Student Name } & \text { Marks } \\ \hline A & 55 \\ B & 90 \\ C & 40 \\ D & 80 \\ E & 85 \\ F & 95 \\ G & 82 \\ \hline \end{array} $$
(i) Find out the students who have scored more than 80 marks, and display them in descending order according to their marks?
(A) SELECT student-name,marks FROM Result WHERE marks $>80$ ORDERBY marks DESC
(B) SELECT FROM Result WHERE marks $>80$ ORDERBY marks DESC
(C) SELECT student-name,marks FROM Result WHERE marks $>80$ ORDERBY marks
(D) (A) and (B)
(ii) From the above table, find out the top-most three students.
(A) SELECT student-name FROM Result ORDERBY marks DESC $>3$
(B) SELECT student-name FROM Result ORDERBY marks DESC $=3$
(C) SELECT student-name FROM Result ORDERBY marks DESC limit 3
(I) None of these

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

ORDER BY Clause

The ORDER BY clause in SQL is utilized to sort the returned records in either ascending or descending order based on one or more columns. This is crucial for query results where the order of data is important, such as ranking or displaying top values.

LIMIT Clause

The LIMIT clause in SQL is used to restrict the number of records returned by a query. This is particularly useful when only a subset of results is needed, such as retrieving the top few records based on a specified criterion.

SQL SELECT Statement

The SQL SELECT statement is used to retrieve data from a database. It specifies the fields to be retrieved and the table or tables from which the data is drawn, forming the basis for any query that requests information from a relational database system.

WHERE Clause

The WHERE clause in SQL is used to filter records according to specified conditions. It restricts the rows returned by a query, ensuring that only records that meet the given criteria are selected.

Transcript

Please give Ace some feedback