I want a help abt sql .I am using SQL Server 2008. I have a table like below
I want output like below
[stdId] [stdmarks]
.1 .........70
.1 .........20
.1 .........40
.1 .........50
.1 .........60
.2 .........25
.2 .........42
.2 .........53
.2 .........89
create query
CREATE TABLE...