When you join two tables and you want to count only the first table, you can use the distinct command.
select a.OrderID, count(distinct a.Id) as Total from tblOrder a
inner join tblOrderDetail b on a.OrderID = b.OrderID
When you join two tables and you want to count only the first table, you can use the distinct command.
select a.OrderID, count(distinct a.Id) as Total from tblOrder a
inner join tblOrderDetail b on a.OrderID = b.OrderID
For further actions, you may consider blocking this person and/or reporting abuse
Datadog sat down with Google’s Director of AI to discuss the current and future states of AI, ML, and LLMs on Google Cloud. Discover 7 key insights for technical leaders, covering everything from upskilling teams to observability best practices
Mike Young -
Mike Young -
Mike Young -
Mike Young -
Top comments (0)