Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Vertical2HorizontalTable
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
CREATE TABLE VerticalTable ( Id int, Att_Id varchar(50), Att_Value varchar(50) ) INSERT INTO VerticalTable SELECT 1, 'FirstName', 'John' UNION ALL SELECT 1, 'LastName', 'Smith' UNION ALL SELECT 1, 'Email', 'john.smith@dummy.com' UNION ALL SELECT 2, 'FirstName', 'Jack' UNION ALL SELECT 2, 'LastName', 'Daniels' UNION ALL SELECT 2, 'Email', 'jack.daniels@dummy.com' SELECT * FROM VerticalTable SELECT [Id], [FirstName], [LastName], [Email] FROM ( SELECT Id, Att_Id, Att_Value FROM VerticalTable ) as source PIVOT ( MAX(Att_Value) FOR Att_Id IN ([FirstName], [LastName], [Email]) ) as target
View schema
Execution time: 0,03 sec, rows selected: 8, rows affected: 6, absolute service time: 0,19 sec
edit mode
|
history
Id
Att_Id
Att_Value
1
1
FirstName
John
2
1
LastName
Smith
3
1
Email
john.smith@dummy.com
4
2
FirstName
Jack
5
2
LastName
Daniels
6
2
Email
jack.daniels@dummy.com
Id
FirstName
LastName
Email
1
1
John
Smith
john.smith@dummy.com
2
2
Jack
Daniels
jack.daniels@dummy.com