Higher Than 75 Marks

  • + 0 comments

    select name FROM students WHERE marks>75 ORDER BY RIGHT(name,3),Id ASC;

    you have to output name of a student select right(name,3) from students where marks > 75 order by ID asc ;and this query gives last three character of name only thats why its not working.