The IF/THEN/ELSE construct you are using is only valid in stored procedures and functions. Your query will need to be restructured because you can’t use the IF() function to control the flow of the WHERE clause like this. The IF() function that can be used in queries is primarily meant to be used in the … Read more
You know, there might be an easier way but the first thing that pops to mind is: Declare @SumVal int; Select @SumVal=Sum(Amount) From Expense; Print @SumVal; You can, of course, print any number of fields from the table in this way. Of course, if you want to print all of the results from a query … Read more
2 and 3 are the same in MySQL, functionally 1 is also the same. where 1 is not standard so, as others have pointed out, will not work in other dialects. People add where 1 or where 1 = 1 so where conditions can be easily added or removed to/from a query by adding in/commenting … Read more
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: MS official http://www.sql-server-helper.com/sql-server-2008/row-value-constructor-as-derived-table.aspx