you can use
ORDER BY
cause like this...
DECLARE @TEMP AS TABLE (
ID INT IDENTITY(1,1)
,NAME VARCHAR(10)
,COUNTRY VARCHAR(10)
,CODE VARCHAR(15)
)
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Adam' ,'USA' ,'77854358')
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Jhone','UK','85558546')
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Michal','UK','85578966')
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Sara','UK','81112452')
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Kone','Can','55866149')
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Noura','USA','79558681')
INSERT INTO @TEMP (NAME,COUNTRY,CODE) VALUES('Adam','USA','77896669')
SELECT * FROM @TEMP ORDER BY COUNTRY DESC
and out put of this query is like this...
ID NAME COUNTRY CODE
1 Adam USA 77854358
6 Noura USA 79558681
7 Adam USA 77896669
2 Jhone UK 85558546
3 Michal UK 85578966
4 Sara UK 81112452
5 Kone Can 55866149