hi ! i need help about pivot in SQL ; I need to know how to convert N rows to columns in SQL without using Pivot ;
sample :
name value id
1 name Rayan 1
2 gender male 1
3 salary 1000 1
..... ..... ...... ......
.
N xxx valueN IdN
to obtain :
id name Gender Salary
1 Rayan male 1000
N ..... .... ....