python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - subquery

DB2 - Select count(*) not working properly on subquery

Here follows 2 querys that should bring the same result, but unfortunately thats not the case. They have just 1 different line: 1. Result = 403 SELECT count(*) FROM (SELECT CONSULTORA.ID CONSULTORA_ID...
test-img

Matheus Santz

group-by

count

subquery

db2-luw

Votes: 0

Answers: 0

ASP.NET CORE labmda sum subquery

I have 3 entities. VehicleType has a many vehicles and each vehicle has a many rents. Each rent has TotalKm. I want to know the sum of TotalKm for all rents for each vehicle type. I try this: public a...
test-img

Marcelo Antunes Fernandes

asp.net-core

lambda

subquery

Votes: 0

Answers: 0

SQL Query to fetch the customers registered in the DB without email address(CS can have phonenumber and email in the same field but duplicating)

I need help with writing this query please , in the Database - the customer is registered twice , one row with the email address in the VALUE field and the other row with phone number in the SAME VALU...
test-img

Zoghlami TAHER

sql

postgresql

subquery

union

sql-scripts

Votes: 0

Answers: 2

Latest Answer

I suggest that you use the following query, modified with the exact column and table name. We use string_agg to coalesce all the value fields for the same customer id and only show them if none of the...
test-img

user18098820

Running total for SQL column that is part of subquery

Lots of posts here describe how to do running totals, but I'm faced with a situation where the running total needs to be that of a column that's calculated using a sub-query (which means my current OR...
test-img

Tanaka Saito

sql

sql-server

subquery

cumulative-sum

Votes: 0

Answers: 3

Latest Answer

You might need to use [] to contain column name instead of ' which means string value, also we need to give subquery an alias name. SELECT TimePeriod, [Total Per Period], [Percentage of To...
test-img

D-Shih

Posts

Questions

Blogs

Jobs