delete the last row in a table using sql query?

This is not the best but a different solution.

DELETE FROM marks 
WHERE  id = (SELECT id 
             FROM   marks 
             ORDER  BY id DESC 
             LIMIT  1);

@Abhshek's Answer is right and works for you but you can also try the following code if the id is not increment

DELETE FROM MARKS WHERE ID=(SELECT MAX(id) FROM MARKS)

If id is auto-increment then you can use the following

delete from marks
order by id desc limit 1

Related