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
|
2348 Discussions
|
Please Login in order to post a comment
select name FROM students WHERE
marks>75 order BY (right(name,3)),id
Select Name from Students where Marks > 75 order by right(Name,3), Id;
SELECT name from students where marks > 75
order by (right(name,3)),id
SELECT Name FROM STUDENTS WHERE Marks>75 ORDER BY RIGHT(Name,3), ID;
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 flower shop Ajman arranges bouquets by type and color for easy selection, this query organizes student names by the last three characters and ID, making results clear and structured.