home
I originally had a placed in the where statement that seq1 (most recent physical address) would be...
I have a query (condensed version - edited to add the SUM items for clarity) - SELECT STORENBR AS...
I have developed a query using two pivot table, now I want to add a zero where the value is...
I am trying to handle some data in the following way. If the entry is numeric, cast it as an...
I've a table as shown in the SQL Fiddle. CREATE TABLE `test` ( `id` varchar(250) NOT NULL, ...
I have a table of users and I want users to update some of their details (data), but if a user...
I have a parent system table called lt_program_data it contains customer data, percents tracked for...
I have a scenario where for the second employee (in the screenshot attached) there is no record...
I have the following SQL: Select MyNumber FROM (SELECT to_number(Name) AS MyNumber FROM...
Column MaxPlaces sometimes has a value and sometimes is just NULL. I have to send this procedure to...
I am working on a Hive table on Hadoop and doing Data wrangling with PySpark. I read the...
This question already has an answer here: How can I include null...
I would like to find the rows which fulfill certain conditions with their values. The values and,...
I've a multidimensionnal array like that, and I wan't to check if all of the "open_at" and...
I have a stored procedure where it can return no row, in that case I would like to put 'Other' as a...
2 months ago

Not working !==NULL

In my app I have a table in where I'd like lo highlight some rows if a date field is empty, here's...
I have this stored procedure in MySQL, its suposed that should works but it doesn't. I put a table...
Sometimes SUM(c.Quantity) is null so I need to convert it to 0, tried to use case/isnull and so on,...
Suppose that I have: case when @ID ='2386002' then...
2 months ago

ISNULL prints *

I am encountering this strange behavior (Okay maybe not strange but beyond my understanding) when...
I have a database table "Category" which can have a self-reference. If self-reference is null, then...
I have a column PhoneNumber varchar(50) and i want to build an expression for a derived column...
I have 3 tables, RA, CC and EC. RA has a foreign key, 'ec' which maps to 'code' column in the EC...
Knowing the differences of array_key_exists() and isset() in PHP, I see a lot of advocates on the...
[SOLVED] how to remove the NULL value only in the field provider_order only, in my case the table...
3 months ago

ISNULL MIN together

Good morning folks. I have had a good search but cant quite find an answer (or one I can...
current table (TARGET) field1 field2 field3 field4 apple1 apple2 apple3 apple4 The...
$variable = array("apple" , "orange" , null, "apple2"); DB::statement("UPDATE table1 ...
Sql query UPDATE MyTable SET Field1 = IsNull(@Field1, Field1), Field2 =...
Well, I know in fact that "!" means NOT, and I quite understand the "IsNullOrWhiteSpace" function...