Write a MySQL statement to sort the students in descending order of the last name
Question
Write a MySQL statement to sort the students in descending order of the last name
Solution 1
Sure, here is a MySQL statement that sorts students in descending order of the last name:
SELECT * FROM students
ORDER BY last_name DESC;
Here's a step-by-step breakdown of the statement:
-
SELECT * FROM students: This part of the statement selects all columns from thestudentstable. -
ORDER BY last_name DESC: This part of the statement sorts the selected rows based on thelast_namecolumn in descending order (DESC). If you wanted to sort in ascending order, you would useASCinstead ofDESC.
Solution 2
Sure, here is a MySQL statement that sorts students in descending order of the last name:
SELECT * FROM students
ORDER BY last_name DESC;
Here's a step-by-step breakdown:
-
SELECT * FROM students: This part of the statement selects all columns from thestudentstable. -
ORDER BY last_name DESC: This part of the statement sorts the results by thelast_namecolumn in descending order (DESC). If you wanted to sort in ascending order, you would useASCinstead ofDESC.
Similar Questions
Dr Stephane Nwolley wants to identify the students with a score greater than the average. Write a MySQL statement to identify these students. Display the student names (Join first name and last name and call it full_name), the score of the student, and their major.
Write a query to display all student details whose sname starts with ‘s’(case sensitive) and is of length between 5 and 20 and squal as ‘undergraduate’(case sensitive). Display the records sorted in ascending order based on sid.
ou have a database that tracks students in the students table by student_id. Students may get warnings for low grades or poor behavior. The warnings are tracked in the warnings table where the student is referred to by student_id.You need to create a query that finds the first and last name of the student who has the most records in the warnings table. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)
Given 3 tables, students(id, name) , courses(id, name) , grades(id, course_id, student_id, grade), find the top 100 students based on their average grades sorted descendingly by the average grade and in case multiple students have the same average grade, sort them lexicographically in ascending order by their names. Your query should output a table with the following columns (name, average_grade).
SELECT nameFROM instructorWHERE dept name = ’Physics’ORDER BY name;By default, the order by clause lists items in ______ order.AnyAscendingSameDescending
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.