I'm trying to filter a query using a composite key, however, I'm not sure how to filter using the...
I am a SQL novice, but was given a task of comparing two data sets for determining differences...
I have a query like this: SELECT * FROM table WHERE t1.name||t1.lastname||... ilike ANY...
I've been reworking the parentheses on this query for a bit to no avail. Can someone point me to...
Beginner here..... I am creating a select statement with many "where" & "or" clauses, but I...
I would like to understand how I can use the content of a cursor in a Where clause of a SQL...
select * from table1 where ( ( --group1 amount_1 > 0 or amount_2 > 0 ...
What I want to do is to select the record from database based on two conditions, the first...
I solved my problems with UNION ALL by myself nearly completely. Only I have a problem with this...
I have below dynamic WHERE condition in XML mapping which is working fine: WHERE ...
In my database I have records which have a column with comma separated values like below: I want...
I have an impression, that AND and OR functionality are switched. Following code queries table,...
Wondering why 2 queries independently execute fine and when clubbed together takes the query into...
Here is sample Linq statement: var query = (from fm in db.table1 join fe in db.table2 on fm.Id...
I am trying to filter one of columns that has DB nulls. I am trying to see how could I merge the...
This line is throwing IndexOutOfRange exception: DataTable.Where(ss =>...
I'd like to have a table which contains values to compare against and operator to use (=, !=, ~, !~...
I am creating a system using Laravel and AngularJS where I assign tasks to users. Multiple tasks...
i tried to show 2 tables value in one gridview in asp.net using where clause on date string s...
I have a csv file that list of sale_ids (about 10K entries). I am wondering if there is a way to...
I have 2 table Bank and Applicant, how to query show all bank and count how much applicant that use...
im going to develop web with laravel framework. this is my code : $valws =...
how to tell in which column the search string was found? My query select DISTINCT t1.id, ...
We have a sql query where we use 3 inner joins and a massivly complex where-condition. We have the...
I have a table called finalres in my database which has list of statuses and accounts. I want to...
I have a set of data (dozens of columns from different table in different type) and i want to...
This question already has an answer here: Why Are Floating Point...
MySql statement does not return any results when I include WHERE LIKE. Statement: SELECT...
I'm trying to customize the "Sales by Product" report in WooCommerce to limit just to a specific...
Needed help in using multiple search in where clause: Trying to write a query which would return...