merge multiple tables together – Mysql
i seem to be a little confused on what to do. I have 3 csv files, each have the the common rows of name age and sex. First csv file shows the common data of the 3 and proceeds to…
Trouble with adding additional column with JOIN – Postgresql
Have two tables: Task: Make a table with fields: name of acquiring_company; name of acquired_company; price_amount; funding_total; Ignore those transactions in which the purchase amount (price_amount) and amount of investment (funding_total) is zero SELECT a.acquiring_company_id, a.acquired_company_id, a.price_amount, c.funding_total FROM acquisition…
How to get all duplicates row in MySQL
I have a tables companies and addresses and need to get all duplicated rows Checking columns is companies.phone_number and addresses.columns Table companies uuid name phone_number 5esd A INC. 667-784-343 6dcv B INC. 866-653-343 56js C INC. 111-222-333 tug8 D INC.…
How can I retrieve the rows of all non-latest records whereby the latest is always excluded? – Postgresql
How would I get the non-latest record for each name. I want to get results such that if a name has one record, it is excluded because it is the latest. If a name has two records, I'll include the…
how to get duplicate data from table with sql – Mysql
I have a table directors and need to get all duplicated rows Checking columns is name and phone_number Table directors uuid name phone_number 5esd ari 111-222-333 6dcv lee 111-222-333 56js poo 667-784-343 tug8 ari 866-653-343 I need these rows: uuid…
How to extract text from jsonb array in PostgreSQL
I want to be able to extract text from jsonb array in a new column as text. This is my SQL table. Id. ErrorCode. 101 ["exit code: 1"] 102 ["exit code: 3"] 103 ["OOMKILLED"] This is my column definition '[]'::jsonb…
How to find 7 consecutive non zero values in SQL? – Mysql
If we have a table of 15 columns, the first one is id, and the other columns have numeric data type, in MySQL or a similar languages, how can I find if the record have 7 consecutive non zero values,…
How to return all row values for any given particular column in MYSQL Database table – meant to be used for dynamic SQL query calls on JDBC
I am working with a JDBC and am trying to figure out how to dynamically create queries - which is proving to be a rather challenging feat. What input can I put in a SQL query to have it return…
How to conditional SQL select – Postgresql
My table consists of user_id, revenue, publish_month columns. Right now I use group_by user_id and sum(revenue) to get revenue for all individual users. Is there a single SQL query I can use to query for user revenue across a time…
POSTGRES – How do i optimize this join query – Postgresql
I have one table as below which stores employees details empid attribute value start_date end_date E1 Active FALSE 2020-01-01 2022-05-05 E1 Active TRUE 2022-06-06 9999-12-31 E1 Branch NYC 2022-01-01 9999-12-31 E2 Active TRUE 2020-01-01 9999-12-31 Then another table which have…