Can you have if-then-else logic in SQL? [duplicate]

by

You can make the following sql query

IF ((SELECT COUNT(*) FROM table1 WHERE project = 1) > 0) 
    SELECT product, price FROM table1 WHERE project = 1
ELSE IF ((SELECT COUNT(*) FROM table1 WHERE project = 2) > 0) 
    SELECT product, price FROM table1 WHERE project = 2
ELSE IF ((SELECT COUNT(*) FROM table1 WHERE project = 3) > 0)
    SELECT product, price FROM table1 WHERE project = 3

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  3. Should I use != or for not equal in T-SQL?
  4. Conversion failed when converting date and/or time from character string while inserting datetime
  5. Foreign Key to non-primary key
  6. How should I pass a table name into a stored proc?
  7. Difference between left join and right join in SQL Server [duplicate]
  8. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  9. Get the last inserted row ID (with SQL statement) [duplicate]
  10. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  11. Get the week start date and week end date from week number
  12. Run all SQL files in a directory
  13. Rename column SQL Server 2008
  14. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  15. How to get the numeric part from a string using T-SQL?
  16. SQL Server Update Trigger, Get Only modified fields
  17. Selecting first row per group
  18. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  19. SQL Server Convert integer to binary string
  20. How to find column names for all tables in all databases in SQL Server
  21. SQL Row_Number() function in Where Clause
  22. SQL update trigger only when column is modified
  23. Backup a single table with its data from a database in sql server 2008
  24. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  25. COALESCE Function in TSQL
  26. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  27. Try_Convert for SQL Server 2008 R2
  28. SQL Server variable scope in a stored procedure
  29. SQL Sort Order with Null values last
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment