Case in Select Statement

by

The MSDN is a good reference for these type of questions regarding syntax and usage. This is from the Transact SQL Reference – CASE page.

http://msdn.microsoft.com/en-us/library/ms181765.aspx

USE AdventureWorks2012;
GO
SELECT   ProductNumber, Name, "Price Range" = 
  CASE 
     WHEN ListPrice =  0 THEN 'Mfg item - not for resale'
     WHEN ListPrice < 50 THEN 'Under $50'
     WHEN ListPrice >= 50 and ListPrice < 250 THEN 'Under $250'
     WHEN ListPrice >= 250 and ListPrice < 1000 THEN 'Under $1000'
     ELSE 'Over $1000'
  END
FROM Production.Product
ORDER BY ProductNumber ;
GO

Another good site you may want to check out if you’re using SQL Server is SQL Server Central. This has a large variety of resources available for whatever area of SQL Server you would like to learn.

More Related Contents:

  1. How do I perform an IF…THEN in an SQL SELECT?
  2. Can I use CASE statement in a JOIN condition?
  3. “CASE” statement within “WHERE” clause in SQL Server 2008
  4. OR is not supported with CASE Statement in SQL Server
  5. SELECT query with CASE condition and SUM()
  6. Dynamic order direction
  7. Is it possible to write single query on two table which are not connected to each other?
  8. Import CSV file into SQL Server
  9. How to create a table from select query result in SQL Server 2008 [duplicate]
  10. Are there any disadvantages to always using nvarchar(MAX)?
  11. Creating an index on a table variable
  12. Turn off constraints temporarily (MS SQL)
  13. Parse comma-separated string to make IN List of strings in the Where clause
  14. How do I execute a stored procedure once for each row returned by query?
  15. How do I calculate a running total in SQL without using a cursor?
  16. Transfer data from one database to another database
  17. Concat field value to string in SQL Server
  18. How to update and order by using ms sql
  19. Using Excel VBA to run SQL query
  20. How to store image in SQL Server database tables column [duplicate]
  21. SQL “between” not inclusive
  22. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  23. Benefits Of Using SQL Ordinal Position Notation?
  24. SQL Server replace, remove all after certain character
  25. Does UNION ALL guarantee the order of the result set [duplicate]
  26. Inserting rows into a table with one IDENTITY column only [duplicate]
  27. How to retrieve field names from temporary table (SQL Server 2008)
  28. When using GETDATE() in many places, is it better to use a variable?
  29. Group consecutive rows of same value using time spans
  30. SQL add filter only if a variable is not null

Leave a Comment