Selecting rows where remainder (modulo) is 1 after division by 2?
MySQL, SQL Server, PostgreSQL, SQLite support using the percent sign as the modulus: WHERE column % 2 = 1 For Oracle, you have to use the MOD function: WHERE MOD(column, 2) = 1
where-clause
sql query if parameter is null select all
Try this: SELECT * FROM MY_TABLE WHERE @parameter IS NULL OR NAME = @parameter;
What is the purpose of using WHERE 1=1 in SQL statements? [duplicate]
It’s also a common practice when people are building the sql query programmatically, it’s just easier to start with ‘where 1=1 ‘ and then appending ‘ and customer.id=:custId’ depending if a customer id is provided. So you can always append the next part of the query starting with ‘and …’.
Usage of where in if let assignment in Swift
In Swift 3 this syntax has changed. What was if let x = y, a = b where a == x { Is now if let x = y, let a = b, a == x { The justification is that each sub-clause of the if … { is now an independent boolean test. See … Read more
In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
The ON clause defines the relationship between the tables. The WHERE clause describes which rows you are interested in. Many times you can swap them and still get the same result, however this is not always the case with a left outer join. If the ON clause fails you still get a row with columns … Read more
Checking an input param if not Null and using it in where in SQL Server
You can use IsNull where some_column = IsNull(@yourvariable, ‘valueifnull’) EDIT: What you described in the comment can be done like: where (@code is null or code = @code)
Oracle SQL : timestamps in where clause
to_timestamp() You need to use to_timestamp() to convert your string to a proper timestamp value: to_timestamp(’12-01-2012 21:24:00′, ‘dd-mm-yyyy hh24:mi:ss’) to_date() If your column is of type DATE (which also supports seconds), you need to use to_date() to_date(’12-01-2012 21:24:00′, ‘dd-mm-yyyy hh24:mi:ss’) Example To get this into a where condition use the following: select * from TableA … Read more
MySQL Select last 7 days
The WHERE clause is misplaced, it has to follow the table references and JOIN operations. Something like this: FROM tartikel p1 JOIN tartikelpict p2 ON p1.kArtikel = p2.kArtikel AND p2.nNr = 1 WHERE p1.dErstellt >= DATE(NOW() – INTERVAL 7 DAY) ORDER BY p1.kArtikel DESC EDIT (three plus years later) The above essentially answers the question … Read more
Is a JOIN faster than a WHERE?
Theoretically, no, it shouldn’t be any faster. The query optimizer should be able to generate an identical execution plan. However, some database engines can produce better execution plans for one of them (not likely to happen for such a simple query but for complex enough ones). You should test both and see (on your database … Read more
Dynamic WHERE clause in LINQ
(source: scottgu.com) You need something like this? Use the Linq Dynamic Query Library (download includes examples). Check out ScottGu’s blog for more examples.