SELECT a.stname, a.score FROM student a WHERE (SELECT COUNT (DISTINCT (b.score)) FROM student b WHERE a.score<=b.score) BETWEEN 1 AND 5

ORDER BY a.score DESC

I think this is the required solution.

hi,

replace function works in your case. May be your criteria is not satisfying to get the records to be updated.

create table #temp

(cntry varchar(12))

insert into #temp

values ('F R A N C E')

select...

Uninstall SQL Server by using the Add/Remove Programs applet in Control Panel. After you remove SQL Server from the computer, Microsoft recommends that you restart your computer to remove files...

U can add spaces to string by enclosing the spaces in the two single quotes. For eg

declare @str1 varchar(10)

set @str1  = 'abcdef'

select @str1  +'        '+ 'ghi'

the spaces in the...

Declare the @Dy variable  as  Varchar(12) instead of Varchar only.

when you declare @Dy Varchar it takes only the first character of the string assigned to it. For example

Decalre @Dy varchar

set...