Stored Procedure

[yrstruly]

I have a table: Named  HighScores  

"INSERT HighScores 
VALUES ('Bob', 2500, '2 Jan 2013 13:13'),
           ('Jon', 1500, '2 Jan 2013 13:15'),
       ('Amy', 3500, '2 Jan 2013 13:18')"

I want to create a stored procedure that would:

The score must show the TOP 5 or so people.

Show your position on the high score board

Show the person in front and below you on the high score board.

If the scores are tied, the person who got it the most recent is shown higher.

Can anybody assist me please?

[Morshed Chittagong]

On 9/19/2019 at 3:02 PM, yrstruly said:

Show your position on the high score board

Show the person in front and below you on the high score board.

What do u mean by YOUR in your post? what you need is not clear on the post. pls elaborate. 

[Yurko]

It doesn't work for MySQL Workbench:

CREATE PROCEDURE SelectAllCustomersAS
SELECT * FROM Customers
GO;

EXEC SelectAllCustomers;

But it is working:

DELIMITER //

CREATE PROCEDURE SelectCategory()
BEGIN
    SELECT * FROM category;
END //

CALL SelectCategory();