I am trying to select the record but not getting the record I wanted. here is my sqlfiddle http://sqlfiddle.com/#!17/5296a/1 so when I selects the record using below query it gives me result with the title DDDDD. it should give me GGGGGGGG. I wanted to check if there is any record with author_id=3 and greater…
Tag: where-clause
Maintain order when using SQLite WHERE-clause and IN operator
Consider the following tbl: For reference, tbl looks like this: When issuing the following statement, the result will be ordered according to ID. However, I need the ordering to adhere to the order of the passed list of values. Here’s what I am looking for: Answer You can create a CTE that returns 2 col…
How use case statement alias in where clause
I’m trying to use a case statement and the results to in an alias, but I need to use the alias in my where clause and this doesn’t seem to be working. How do I use the alias (isPrimary below) in my where clause. See comment where I’m trying to use isPrimary in my where clause, which doesn…
How do I write a Ruby where clause with dates and array lookup?
I want to do something like the above. I first want to check if the model external id is in the array of appointment_ids, then make sure it is not soft deleted and then check if the record start time is between dates.. Any help much appreciated. Answer You don’t need to use a SQL string to create that q…
Create SQL statement with mulitple AND
I have a problem with creating right SQL request. This is my table: I would like to display all items that: -Are in warehouse A in number less than 2 -Are in watehouse B in number grater than 0 At the same time. I would expect item1 will be displayed. My code so far is: I know that warehouse =
Select only products that are active via query from two tables
I have a query that provides me with a list of productId:s that I then match with a products table.. But how would I adjust the query to give me only productId:s that are active (active=1)? Answer You can use join:
How do I construct my WHERE clause to pull records based on this specific criteria?
I am using SQL Server 2014 and I have a T-SQL query running against a specific Table (t1). Table t1 includes 3 columns named [HR_LeftDate], [Payroll_LeftDate] and [Status]. In that table, there are records which have their [HR_LeftDate] and [Payroll_LeftDate] as ‘NULL’ and some other records which…
Syntax error while using WHERE clause in PostgreSQL
I’m trying to run some queries related to the University database in PostgreSQL. To find students advised by instructors from different departments, I used- However im getting the following error: ERROR: syntax error at or near “where” LINE 3: student join instructor where student.dept_name …
SQL query filter down to only applicable rows
How would I select a query like this? I am a bit confused because this would return nothing since any of the rows do not fulfill any of the “where clauses”.. What I would like is the answer …
SQL an ID in one group and an id from another
I have a request where I need a count where a participant completed an activity under one id (the gateway to completing other things) and then an id in a list of other ids. Right now, this code is only coming back with the the a count of the one id but not saying that one id complete + the