I'm trying to sum a column based on a condition in another column with partition by in SQL, but it's not working. So I hope somebody can help me with this. My table is like this: Group_1 Group_2 Date Value…
I am listing features of a building. But I don't want to display features that are not available. The availability values are stored in database. And I am using custom scrollview. I have attached the image where it was initially.…
I've got the following table structure for storing IPs (PostgreSQL 11.14): CREATE TABLE ips ( ip INET ); INSERT INTO ips VALUES ('10.0.0.4'); INSERT INTO ips VALUES ('10.0.0.0/24'); INSERT INTO ips VALUES ('10.1.0.0/23'); INSERT INTO ips VALUES ('10.1.0.0/27'); I need…
I do have one table with 2 columns and another with 2 columns employee(id, transaction_date), employee_1(id, transaction_date) Below is the query i tried, but it's returning an error SELECT COUNT(DISTINCT id) / COUNT(DISTINCT id) FROM employee, employee_1 Error is SQL…
I am struggling getting the difference of two Timestamps in milliseconds. My current approach was SELECT * FROM EXTRACT(EPOCH FROM(NOW()::TIMESTAMP - '2022-10-23 16:34:53.227')) which was described on a bad website as returning the difference in seconds but in fact returning…
I have a sales table, where it shows the information below ID_sale sales_person sale_date 7 50 19/10/2022 6 43 17/9/2022 5 50 15/3/2022 4 43 13/2/2022 2 50 22/1/2022 3 10 05/2/2022 1 12 07/1/2022 and I want to create…
I'm using pgsql to find the cage number (cno) that holds the largest number of animals but doesn't have a bird in it. The way I tried to do it is by creating a table that counts the number of…
I'm trying to get something I thought should be relatively simple (it works in Oracle and MySQL). The PostgreSQL fiddle for the code below is available here - just change the server to check out the others. Very simple test…
I have table user: user_id status 1010 1 1010 3 1010 3 1011 5 1011 2 1011 3 1012 3 1012 3 i want to filter user_id with the condition that the number "3" in the status column cannot appear…
This query has so many joins and i have to apply conditions on joined table columns to get the desired results but query becomes slow when i apply condition on a datetime column. Here is the query select distinct v0_.id…