I have an SQL query: select * from sval where fid = 994 and val = 'XLON'; that returns id fid val 100 994 's' 102 994 'd' 103 994 'd' 104 994 'd' 110 994 's' 140 994 's'…
I have the following table with a combo key columns CREATE TABLE IF NOT EXISTS MyTable ( ColumnID1 integer NOT NULL, ColumnID2 integer NOT NULL, ColumnName character varying(1000), CONSTRAINT "MyTable_pkey" PRIMARY KEY (ColumnID1, ColumnID2), CONSTRAINT "MyTable-ColumnID1-ColumnName-Unique-Key" UNIQUE (ColumnID1, ColumnName) )…
There is table called accounts containing transaction data with columns account_number, date, balance … I want to get the balance for each account_number where the balance<-1000000000 on the last day of each account transaction, and sort the output by balance…
I'd like to make a sql table something like this. I want to insert 80 data records in my SQL databse with the same ID number. How can i overcome this sql database?
I have the following tables (simplified) in Postgres: CREATE TABLE party( id int PRIMARY KEY, family_name varchar(50) NOT NULL ); CREATE TABLE election( id int, country_name varchar(50) NOT NULL, e_type election_type NOT NULL, e_date date NOT NULL, vote_share numeric, seats…
I am creating a jsonb object using jsonb_build_object in PostgreSQL. The problem is that it adds jsonb_build_object column in the output. Please refer to the screenshot and query below: select jsonb_build_object( 'country_name', country_name, 'country_code', country_code, 'currency_code', currency_code ) from table…
I have a MySQL table entries with a primary key id. Also I have a pivot table entries_tags with foreign keys entry_id and tag. tag is plain text by the way, I know this should be normalized but that is…
I have a main table called pics that has an ID number and the origin site from which it was pulled from. I also have another table called tags that has a list of all the tags that were also…
I have a task table with 1000 rows in my Postgres 12 database. I need to get last 100 rows non-executed, set column executed to 1 and return that selected rows. If I do code below, it updates all 1000…
My table looks like this: Name Date of Birth John 02-02-1990 15:30 Esther 05-05-1980 13:30 Mark 07-10-1980 12:30 I want a query that returns this. Age Count 33 1 43 2 I've seen other solutions like what we have here…