I have a table in a PostgresSQL where I am doing a migration from other database. I have a id field which is defined by Auto increment using sequence feature in postgres. Whenever I truncate the table and insert the…
My data looks like this date category subcategory price 20230510 A LMN 10 20230510 A PQR 20 20230511 A LMN 50 20230511 A PQR 10 In my table I am getting subcategory LMN and PQR along with price, I need…
I have the next Tree Structure : This structure is represented in the database with the next Table: --------------------------------Employees------------------------------------------- ------------------------------------------------------------------------------------- | Employee_name | Global_Team | Team | ------------------------------------------------------------------------------------- |name_of_head_of_engineering | - | Engineering | ------------------------------------------------------------------------------------- |name_1_T1 | Engineering | Team_1…