I have three tables in Oracle: HOTEL: Lists the hotel number, hotel name, and the town ID of where the hotel is located. There are 5 rows here (meaning 5 hotels, but not every town has a hotel). …
Join Two Tables Then Transpose Rows From One Table As Column Names
I’m trying to join two tables ColumnNames ID |Name |Type |Status | —————————————————– 1 |Fullname |varchar |Active 2 |Email |varchar |Active …
Is there a best way to get data from snowflake to s3
Is there a best way to get data from snowflake to s3. ? the data snowflake shows will be in s3, but we don’t have access to that bucket. And we only need to get the specific tables from Snowflake not the entire data. Answer you will want the unloading into Amazon S3 documentation. you can ether choose a…
Insert stored procedure output data into a column of a table
I created a stored procedure in SQL Server. The stored procedure subtracts two columns in the same table. How do I insert this stored procedure data into a Inventory column of the dbo.Store table? The …
Big Query data totals are wrong, suspect duplicate rows after LEFT JOIN
I’m trying to join two tables in Google Big Query and I think it’s duplicating a few rows (I’m guessing this because the totals are wrong when I then use the data in Data Studio). To give some …
SQL Server : Order By 2 Columns (get ColumnX > Null First and then Id > Order By DESC)
I want to retrieve records from MSSQL Server according to 2 column values: ColumnX and Id. First I want to retrieve null records of ColumnX (at the top) and then order by Id desc (I just need to …
vlookup in sql and removing duplicates
table A with unique cust id table B with cust_id and a column dealer/direct desired output im trying to vlookup dealer/direct from table B to table A in SQL Conditions: if a customer is dealer i …
Shapiro-Wilk test
In PL/SQL, I want to calculate the Shapiro-Wilk value of my selected data. Apparently, the function DBMS_STAT_FUNCS.normal_dist_fit is able to do it, but it takes a table name as a parameter, and not the result of a select. The values I am working with are numbers, selected after many inner joins. Here is a s…
MySQL SELECT 1 Parent many Children values
I have one parent with many children and I would like from the parent Id selecting value from 3 children, if it’s possible. I tried this SELECT children1.value1, children2.value2, children3.value3 …
Finding the last person working on a project (grouping/having sql?)
I’m trying to figure out how to query the last person (name) who last (date) worked on a project (project). Content TableA (id) | project | name | date ———-+———-+—————…