sqlsql-serverunpivotimdb
Unpivoting movie genres
I'm looking at some movie data from IMDb and I have found a limitation in my knowledge. Here is the data I'm looking at:
I think I will run into problems with this current table. How can I get it so that there are two columns, MovieID and Genre? It would then cause MovieID to not be distinct. Would this require unpivoting?
Any help would be much appreciated!
Solution
I can't see your screenshot so I'm guessing at the columns, but something along the lines of:
SELECT MovieID, "Horror" As Genre
WHERE Horror = 1
UNION ALL
SELECT MovieID, "Comedy" As Genre
WHERE Comedy = 1
UNION ALL
SELECT MovieID, "Drama" As Genre
WHERE Drama = 1
UNION ALL
...
- How to sort all numbers before letters with linguistic sorting?
- How to add multiple columns in AWS redshift with alter table query
- Time and Attendance query, First transaction of the day per person
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL query left join with sum,group by and order by in MS Access
- Update an existing sql table based on content from an external csv file?
- SQL Formatting a string (name)
- Oracle Sql Statement for unique timestamp for each row
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How do I suppress T-SQL warnings when running a script SQL Server 2005?
- How can I group time by hour or by 10 minutes?
- SQL syntax error when trying to create a new table using TypeORM
- How to use PERCENTILE_CONT without over clause? any alternative to it?
- Success message for an end user inside an SQL procedure
- Does Oracle field contain all letters from a string?
- SQL count occurrences based on values in other columns
- How to declare a variable in MySQL?
- Forward fill NULL values in multiple columns
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- PostgreSQL EXISTS in user-defined function always returning true
- Count number of orders for a variation in Woocommerce
- count the number of preliminary and final invoices for each customer
- Extracting valid timestamps in SQL
- MySQL union - alias not visible
- Find values that are 6 characters long in a string, pipe delimited
- How to write this SQL query to find each account balance?
- SQL Query to get latest price
- Join newest price from price-table for all products
- Order By In a SQL Table Valued Function
- Return columns with a single value