Tag: sql

how to show empty value for a int datatype in SQL?

how to show empty value for a int datatype in SQL? I have a case statement on an int datatype column to show empty for the values less than or equal to 0. case when [TotalValue]

Adding sheet name as column to query in Google Sheets

array-formulas google-sheets google-sheets-formula google-sheets-query sql

I have a Google Sheets document with my video game collection. Each console system has its own sheet, but I decided to consolidate all sheets into one new sheet as an overview using a query that looks something like this: This works fine, and I’m satisfied with it. However, my collection is quite large …

SQL LIKE operator with aaa% having strange behavior

sql sql-server

In my case I have patient table with few columns including patient’s firstname and lastname. Application using this table having patient search functionality with firstname and lastname. Having some …

Count child members from parent value

mysql sql

I have a table like conversations and conversation_timelines conversations table example | id | last_active | category_id | |——————————————-| | 1 | …

How to Filter multiple values for Where statement of SQL

sql tsql

Can any help on the below Query in the where statement in T-SQL? I have ID & Product fields in table,in where condition need to exclude the ID not in(’11’,’22’,’33’) only when for Product=’c’ …

Getting Distinct Id(FK) by the latest date in SQL Server

distinct select sql sql-server sql-server-2008

Extract a specific value from a string in a column

select sql sql-server string tsql

Need help with a situation, I need to extract a specific value from a column containing string. The string varies over different records, but the value I need to extract is always preceded by the word “VERSION” I tried to user REVERSE & SUBSTRING but not able to get exact results. Any help wil…