How can I select from list of values in SQL Server

by

Available only on SQL Server 2008 and over is row-constructor in this form:
You could use

SELECT DISTINCT *
FROM (
  VALUES (1), (1), (1), (2), (5), (1), (6)
) AS X(a)

For more information see:

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  3. How do I create a unique constraint that also allows nulls?
  4. How do I get list of all tables in a database using TSQL?
  5. How to convert SQL Server’s timestamp column to datetime format
  6. Escape a string in SQL Server so that it is safe to use in LIKE expression
  7. Storing files in SQL Server
  8. SQL Server: Difference between PARTITION BY and GROUP BY
  9. How do you truncate all tables in a database using TSQL?
  10. Dapper.NET and stored proc with multiple result sets
  11. Import ‘xml’ into Sql Server
  12. Query times out when executed from web, but super-fast when executed from SSMS
  13. T-SQL Dynamic SQL and Temp Tables
  14. Efficient ISNUMERIC() replacements on SQL Server?
  15. Login to Microsoft SQL Server Error: 18456
  16. Adding a query hint when calling Table-Valued Function
  17. Find non-ASCII characters in varchar columns using SQL Server
  18. What is a simple command line program or script to backup SQL server databases?
  19. SQL Server Output Clause into a scalar variable
  20. Replace single quotes in SQL Server
  21. Why is sql server storing question mark characters instead of Japanese characters in NVarchar fields?
  22. sql use statement with variable
  23. How to create a yes/no boolean field in SQL server?
  24. How do I select last 5 rows in a table without sorting?
  25. displaying multiple records by using resultset
  26. How to display two digits after decimal point in SQL Server
  27. Copy table to a different database on a different SQL Server
  28. Include missing months in Group By query
  29. How does SQL Server decide format for implicit datetime conversion?
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment