I am looking for SQL to Find Differences between columns and only till 12 rows and then sum the differences. For example this is the table I have TAB_PAYOUT. Column DIFFERENCE is calculated by substracting the value of column PAY…
I am trying to write a SQL query to get the month end prices for a particular instrument. Table (contains some other columns that can be ignored): instrumentId unitPrice reportedAt 1 90.22 2018-10-28 1 80.55 2018-10-30 1 70.55 2018-09-15 1…
Am building a mini project on how to display a school broadsheet, i have try all i know best but no solution, please i need your help. I have three tables Students, Scores, Subject. This is how i want my…
I want to ask you it is possible to unique fields when a column is 1 ? I have a table sales defined like this: CREATE TABLE sales ( id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, p_id UUID REFERENCES…
I need a query which will display top 7 users by the total indicator of reviews written and ratings given, indicating the total number of pages in the books to which they reviewed Structure of 3 tables given: Books: book_id,…
I have table like this: news_to_category news_id category_id 1 1 1 2 1 3 2 1 2 2 2 3 3 1 3 2 4 1 4 2 4 4 5 2 5 3 5 4 And now I need…
I want to execute 2nd query if first query return no result. I want to get those id age > 20. If no result, want to get number of id with age < 20. In table: id name gender age…
I want it to match only if the number B is not inside a bigger number. e.g. I dont want it to match this: A = "12345" B = 234 I want it to match this: A = "94, 234,…
How do I sum the count of populated fields. An example of the data. The desired output would be. This is what I have managed so far. select m.project_ref, ( select count(*) from (values (m.[EWI/IWI]), (m.Glazing), (m.Solar), (m.CWI), (m.Boiler), (m.TRV),…
i have a really complicated SQL query with alots of where conditions (all are ands) and i have some data. Sometimes some entries are not fetched when executing the sql query, which is fine and expected. But from a business…