Category "where-clause"

mysql with date function query running slow

I found something weird while executing query today and i want to know how this happens. Below is my query: select sum(price) as total from table_a where test

Powershell. Why where {} directive can not find two matching DeviceID? One taken from Win32_VideoController, another from Regedit value

Here is code # | Get DeviceID and Name of GPUs presented in system $GPU_Inf = Get-CIMInstance -Query "SELECT Caption, PNPDeviceID from Win32_VideoController" #

Loopback4 filter inside the scope return list still

I'm using lb4 I have some problems here, I try to find the list with where conditions inside the scope with pagination. const teacherWithStudents = await this.

Two-part conditional sql statement

The statement below is querying a log table and I'm trying to get the max budget depending on the scenario if falls within. Error message: Expressions referenc

return the row where before and after value is lower

I have a table that looks like this: name val 1 1 2 2 3 1 4 2 5 2 6 10 For each row,

How can I write a case sensitive WHERE CLAUSE in SQL Server?

Ok, this one has me stumped. I'm hoping it's not something stupid/obvious... I'm trying to fix addresses in a client database. I have a function that takes a

How to query with multiple 'and' conditions in where clause in Strapi, GraphQL?

Now I am trying to query with multiple _and inside where in Strapi GraphQL playground. The query I am using is: { clients( where: { _and: [{ name:

How can I have IS NULL condition in TypeORM find options?

In my queries I'm using TypeORM find option. How can I have IS NULL condition in the where clause?

UPDATE Query without WHERE Clause

Can the UPDATE query be used without a WHERE clause? And if so in what conditions?

Other Categories