There are 4 fields in my table(abc)
>Id=1,1&&&&1,1 is records in the fileds
>name=khubaib,khubaib
>year=2006,2007
>no=10,9
>
>I get these fields record like. 1, khubaib,10,9
>How will be done.

My table abc has a four fields

id name year no
1 khubaib 2006 9
1 khubaib 2007 10

now i want
id name no no
1 khubaib 9 10