Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Pivot unpivot

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 11, rows affected: 5, absolute service time: 0,16 sec 
edit mode |  history  | discussion
   Agent Country Amount
1 Suman INDIA 1000
2 Suman US 1200
3 Saurav INDIA 800
4 Saurav US 900
5 Saurav US 900
   Agent INDIA US
1 Saurav 800 1800
2 Suman 1000 1200
   Agent Country Amount
1 Saurav INDIA 800
2 Saurav US 1800
3 Suman INDIA 1000
4 Suman US 1200