Select distinct from multiple fields using sql

by

This should give you all distinct values from the table. I presume you’d want to add where clauses to select only for a particular question. However, this solution requires 5 subqueries and can be slow if your table is huge.

SELECT DISTINCT(ans) FROM (
    SELECT right AS ans FROM answers
    UNION
    SELECT wrong1 AS ans FROM answers
    UNION
    SELECT wrong2 AS ans FROM answers
    UNION
    SELECT wrong3 AS ans FROM answers
    UNION
    SELECT wrong4 AS ans FROM answers
) AS Temp

More Related Contents:

  1. SQL/mysql – Select distinct/UNIQUE but return all columns?
  2. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  3. How to select records without duplicate on just one field in SQL?
  4. Whats wrong in this sql query? It throws error [closed]
  5. SQL update from one Table to another based on a ID match
  6. Is there any difference between GROUP BY and DISTINCT
  7. Group by minimum value in one field while selecting distinct rows
  8. SQL SELECT WHERE field contains words
  9. JOIN two SELECT statement results
  10. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  11. How to use DISTINCT and ORDER BY in same SELECT statement?
  12. SQL SELECT speed int vs varchar
  13. Return a value if no record is found
  14. How to get a list of column names on Sqlite3 database?
  15. How to delete from select in MySQL?
  16. SQL to find the number of distinct values in a column
  17. How can I select from list of values in Oracle
  18. Are there any way to execute a query inside the string value (like eval) in PostgreSQL?
  19. Eliminating duplicate values based on only one column of the table
  20. sql query distinct with Row_Number
  21. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  22. SQL: how to select a single id (“row”) that meets multiple criteria from a single column
  23. SQL SELECT from multiple tables
  24. Can select * usage ever be justified?
  25. SQL: Two select statements in one query
  26. Check if two “select”s are equivalent
  27. SQL: Select rows with a column value that occurs at least N times?
  28. SQL query with distinct and sum
  29. Finding unmatched records with SQL
  30. Combine Two Tables in Select (SQL Server 2008)

Leave a Comment