From DBeaver Community, I access my database and create a new SQL query. I write the corresponding code for the CTE I want to create, but it constantly shows a syntax error. I've tried everything, but I can't find the…
Let's say I have two server A and B. Server A is open to public. Server B is only allow connection from server A. My MySQL database is located on server B. From my local machine, how to I connect…
I have a SQL query: select max(date) from index_constituents where (opening_closing ='O' and index_code ='buk350n' and issuer = 'cboe') and date = '2024-04-25'; id date issuer index_code opening_closing 1393 2024-04-25 cboe buk350n O 1394 2024-04-25 cboe buk350n O When I…
I have a function & I'm checking whether the table and column exist or not. If exits, then I need to alter the table. delimiter $$ create function column_exists(ptable varchar(300), pcolumn varchar(100)) returns CHAR reads sql data begin declare result…
When I connect via psql with this command docker exec -it 4e18793cb23c psql -U postgres mytestdb, I can see my database and work with it. But when I connect with dbeaver to my postgres docker container, it doesn't show me…
I have 3 UPDATE statements (that update more than one column) that I would like to execute against a list of id's without having to run the 3 update statements once by one against each id. Here are the 3…
I have a list of ids: select id from id where sid = 2403 The above simply returns a list of ids. e.g. id = 401434786, 401434787, 401434788, etc. When I run one of these ids in my tval table,…
So I have a table where I have column A, B, C,D. Column A has values which have corresponding multiple values in column B.I need to check if all the values in column C and D are null for the…
Docker Desktop 4.21.1 (114176) docker-compose file: # Use postgres/example user/password credentials version: 'latest' services: db: image: postgres restart: always environment: POSTGRES_USER: dbadmin POSTGRES_PASSWORD: mypassword POSTGRES_DB: testdb volumes: - /Volumes/Development/directories/workspace/postgres/data:/var/lib/postgresql/data adminer: image: adminer restart: always ports: - 9080:9080 Docker containers start…
Example Tables: Table: TAB1 Col1 Col2 Col3 Col4 A1 A2 AA1 G1 A1 A2 AA1 G2 Table: TAB2 Col1 Col2 Col3 Col4 A1 A2 AA1 H1 A1 A2 AB1 H2 How to write a query to get Expected Result as:…