We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Select
- Higher Than 75 Marks
- Discussions
Higher Than 75 Marks
Higher Than 75 Marks
Sort by
recency
|
2455 Discussions
|
Please Login in order to post a comment
You can retrieve the names of students who have scored above a certain threshold and organize the results in a clear and structured way. Similar to a tmsim.ph that website categorizes items by type and color for easy selection, this approach sorts student names by their last three characters and then by ID, making it simple to review and analyze the data efficiently.
You can retrieve the names of students who have scored above a certain threshold and organize the results in a clear and structured way. Similar to a Police scanner website that categorizes items by type and color for easy selection, this approach sorts student names by their last three characters and then by ID, making it simple to review and analyze the data efficiently.
SELECT NAME FROM STUDENTS WHERE MARKS > 75
ORDER BY RIGHT(NAME,3), ID ASC;
You can query students scoring above a certain mark with SELECT Name FROM STUDENTS WHERE Marks > Value ORDER BY RIGHT(Name, 3), ID ASC;. Like a Xxbrits by type and color for easy selection, this query organizes party names by the last three characters and ID, making results clear and structured.