Search
 
SCRIPT & CODE EXAMPLE
 

SQL

convert multiple columns to ROws in sql server

select *
  from yourTable
  unpivot (
    Value
    for NewCol in (Value1, Value2, Value3,Value4, Value5)
  ) up
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql age by birthdate 
Sql :: delete a temporary table mysql 
Sql :: with postgres 
Sql :: for json path sql server 
Sql :: how to check table name in current database sql 
Sql :: query to count the number of rows in a table in sqlalchemy 
Sql :: oracle index hint 
Sql :: sql server previous month 
Sql :: postgres user permissions 
Sql :: Write an SQL query to print details of the Workers who have joined in Feb’2014 
Sql :: how to set a column as unique in sql server 
Sql :: error code 1215 cannot add foreign key constraint 
Sql :: mysql delete data in table 
Sql :: mysql 8 geo to json 
Sql :: mysql date format 
Sql :: mysql ilike 
Sql :: login phpmyadmin without password 
Sql :: sql not in 
Sql :: postgresql full text search 
Sql :: sql server list database 
Sql :: limit offset sql server 
Sql :: lower case in sql 
Sql :: mysql connectiion timeout 
Sql :: Get all index postgres 
Sql :: exec procedure pl sql 
Sql :: select only one row sql 
Sql :: sql server port 
Sql :: pl sql search in all packages 
Sql :: sql order by two columns 
Sql :: select odd records sql 
ADD CONTENT
Topic
Content
Source link
Name
1+3 =