I'm attempting to identify the last message sent in a conversation for a set of conversations in...
I'm using an SQL query on a double precision column but I get no ressult. select * from...
I'm trying to write VBA code to get SQL data into Excel. Everything works fine except the WHERE...
I have started creating a stored procedure that will search through my database table based on the...
I am new to MySQL and am learning via PluralSight. I am trying to execute a query with the result 4...
I have a stored procedure with a filter. SELECT * FROM OrderBatch WHERE <field> LIKE...
I have search form where user selects some criteria before they submit request to the server. This...
I have query that has to be filtered based on the argument passed in the function. This will decide...
I have whereIn in Query Builder (Laravel 5.6) $data->whereIn('field1',...
How do i merge this 2 data together to get data like this SELECT A.schlvl AS School,...
I use following two queries to obtain 5 rows from each and display in one list. Is there a possible...
I have so far produced the below code to try and pull the relevant data together. However with the...
I am just learning DB Syntax so im sorry if this is not a relevant question. I'm trying to change...
Since a few days I'm working with this free and open source database that lists all IP addresses in...
I need to create a script with multiple declared variables within the criteria. This is fine where...
Good Day I am facing an issue using CASE expression in where clause, To my knowledge syntax is...
I'm using Hadoop 2.7.3. When you run a hiveql command and have a where clause with 'and' and 'or'...
I want to add comparison parameter in where clause only if my input parameter is not null. I tried...
I want to join query if the value in a post is not equal to blank and it runs perfectly when the...
Can anyone tell me why these two queries don't return the same number of rows ? SELECT...
I found the following piece of code in Contract.hs line 147 Pricing Financial Contracts with...
I have a SQL that needs to execute with or without a condition/predicate in the WHERE clause. This...
My sample query is below and takes a lot of time to execute as there are many records in OPOS, POS4...
after a lot of searching I unfortunately couldn't find a solution for the following task: I need...
select meters.meterno , endpoints.serialnumber , eventlog.eventdate from eventlog inner join...
Ι have a sans table with: +id +date +hour i want write a query with eloquent to...
New learner here. I'm working with two tables in : one with publisher data and one with book...
I am trying build a SQL query that passes a variable that stores the where clause. I inturn, plan...
I have two table in Apache hive. The first is called traffic_violations and the second is called...
Using where clause in inner join but inner join is not selecting what I asked for in query. Here I...