I have a column with value [“NONCODE”,”OFFCR”, “SPVR”, “CORD”] inside. I want to return a value when one of the values in the column matches. Select * from table where column=’SPVR’ –will be true …
What is the purpose of the string “- 4/24” from a record that holds a date?
I have an already generated script that uses the following code: ORDER BY TO_CHAR((A.VERIFIED_DTTM – 4/24),’YYYY-MM-DD’). The output of A.VERIFIED_DTTM is a simple date eg: 09-SEP-19. I was my …
Asp.Net adding an extra td
I’m trying to use an ASP:DataList to display data from my data source. Everything works ok, except I’m getting ASP to add an extra column when there isn’t one. The Header Template and Item Template …
How to improve SQL query performance for HAVING (SQLite)
These 2 queriess are taking several minutes on tables of several millions rows (2 tables: torrents and dates). None of the columns are indexed I believe. I don’t know SQL well. Is there any way to …
refactor duplication of SELECT inside CASE inside SELECT statement
how to refactor this select statement to remove duplication select ( case when ( select my_product_int_attribute — duplication from app_public.products where …
Replace aggregated duplicate value in unique rows
I have a table in which each row represents a different event, with one of the fields providing a value aggregated across all the unique events that occur within that id. For example: +—————…
Add nested column to BigQuery table, joining on value of another nested column in standard SQL
I have a reasonably complex dataset being pulled into BigQuery table via an Airflow DAG which cannot easily be adjusted. This job pulls data into a table with this format: | Line_item_id | Device …
How to fetch related source and destination Flights from table
Hi My table consists of: source destination LA BOS LA BOS Seattle BOS Bos LA BOS Seattle NY Seattle CA LA LA CA LA Chicago CA BOS BOS Seattle I am trying to fetch if my source either …
Merging Rows containing ColumnA predicated by next result(s) of ColumnA
I want the result to display the amount of instances a particular service has been booked for. If the following row has the same service then they should be summed together. Sample Data Expected …
SQL Query not return values
Im running a bit of SQL on my php app, its meant to return a value that gets compared to the value that does get returned. The query is returning two of the 4 values that i need. I’ve tried to …