Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each

19th Dec 2016, 9:34 AM
Akwin Lopez
Akwin Lopez - avatar
2 Answers
+ 5
nice homework m8
19th Dec 2016, 9:51 AM
Ahri Fox
Ahri Fox - avatar
- 1
select Name from Students where marks >75 order by right(Name,3) asc, Id asc;
19th Dec 2016, 9:34 AM
Akwin Lopez
Akwin Lopez - avatar