I am creating an API with express.js for a food app and I can't figure out what is the best (most efficient) way to query the data and send it
In Presto, I have data for a column in a table is as follows: header header 2 {Data: [{'item1': 'stuff1', 'item2': 'stuff2', 'item3': 'stuff3'}, {...}]} cell 2
I have some data rows in AWS Athena table and I am trying to get the data from the last 1 hour. I am using awswrangler, I will post my snippet below. Basically,
Thanks everyone, and thank you @Aaron Bertrand, your answer solved my problem :) ! i am struggling to find a solution to my problem, here is my query in SQL Ser
Not able to remove white space from SQL query output used in pyspark code. I tried, trim,ltrim,rtrim,replace (multiple nested also) and regex replace. Any other
I am using SQL Server Management Studio v18. I have an original transaction that might get adjusted either by amount or by commission%. I want a query to total
I have code that uses row_number() partitioned by date. I would like to create an array that contains data grouped by the row_number that is partitioned by date
I stuck with a spark.sql error that I couldn't solve with answers in stackoverflow, the point is I tried "first_value, collected_list" and they not solving erro
I need to get a list of users with their corresponding bed_id in case user has bed_id and fill with null if user doesn't have bed_id since there will always bee
I'm having an issue with BULK INSERT , the situation is the following : I've a folder path with probably 200 files in it but I've a table with 400 filenames tha
I curently work on few SQL queries (MSSQL 2O14), but only "SELECT" query works with executeQuery(). I had use execute() and executeUpdate() on "INSERT INTO" and
The following is the simplest possible example, though any solution should be able to scale to however many n top results are needed: Given a table like that b
I wanted to add a case when WPIS_ where if frm_code is one of the codes mentioned then we ASSIGNY W if not then B. I get "Syntax error" what I do wrong Rest cod
I made a code allowing me to GET data from an API and insert it into a database. But I encounter a problem my api contains about 20 million data and to insert e
I am trying to do a 3 way JOIN in my query for my Android Room Database. My tables relationships are: Table1 has a 1 to 1 relationship with Table2 Table2 has a
After adding SID to the TRANSACTIONS table, I need to update SID column in TRANSACTIONS based off STORE_NBR in the STORES table. Basically, I want to update the
I need to create a pie chart showing gender distribution for a state pulled through a macro variable. The code for the sql table looks like this: proc sql; crea
I'm trying to improve my query for this topic at hand. I'm trying to find the top 5 and bottom 5 growth rates per state from 2020 to 2021 in my org. The table h
I have been exploring dbt tools and I came across the following code snippet : coalesce(customer_orders.number_of_orders, 0) as number_of_orders I understand th
I have to add a leading 0 in a column called houses, where it is a unique list of 3 digits, but I wanted have to add a leading 0 to it -->