Concatenate values & count rows in Oracle
Osceria
I have a table like this
Trying to get the output as below
The below SQL will do the concatenation of ID2 values for the same ID1. How do I get the count of ID1 based on the number of combinations of ID1,ID2 also?
SELECT
ID1,
LISTAGG(ID2, ', ')
WITHIN GROUP (ORDER BY ID2) "ID2Values"
FROM table_name
eshirvana
SELECT ID1,
LISTAGG(ID2, ', ') WITHIN GROUP (ORDER BY ID2) "ID2Values",
count(*)
FROM table_name
group by ID1
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: FirebaseInstaceId, InstanceIdResult deprecated
- Next: Calling primary constructor from secondary constructor after some calculations are done
Related
TOP Ranking
- 1
Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)
- 2
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 3
pump.io port in URL
- 4
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 5
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 6
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 7
Emulator wrong screen resolution in Android Studio 1.3
- 8
3D Touch Peek Swipe Like Mail
- 9
Double spacing in rmarkdown pdf
- 10
Svchost high CPU from Microsoft.BingWeather app errors
- 11
How to how increase/decrease compared to adjacent cell
- 12
Using Response.Redirect with Friendly URLS in ASP.NET
- 13
java.lang.NullPointerException: Cannot read the array length because "<local3>" is null
- 14
BigQuery - concatenate ignoring NULL
- 15
How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?
- 16
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 17
Can a 32-bit antivirus program protect you from 64-bit threats
- 18
Make a B+ Tree concurrent thread safe
- 19
Bootstrap 5 Static Modal Still Closes when I Click Outside
- 20
Vector input in shiny R and then use it
- 21
Assembly definition can't resolve namespaces from external packages
Comments