samedi 16 avril 2016

How to get the higest number out of the table?

So I have a table of players which I created in sql:

CREATE TABLE Player(PlayerID varchar(10) PRIMARY KEY, level int, region varchar(2), name varchar(10));

And then with the following values:

INSERT INTO Player VALUES ('p001','20', 'eu','phatey');
INSERT INTO Player VALUES ('p002', '15', 'eu', 'hellowz');
INSERT INTO Player VALUES ('p003', '10', 'eu', '3xphhate');

Which I don't understand is how to make use of SUM in order to get the highest level of the players(Mostly because I am doing it wrong since I am pretty newbie with this) any suggestion?

Aucun commentaire:

Enregistrer un commentaire