Skip to content
Advertisement

SQL Count(*) and Query a UNION query

I am a novice to SQL and seeking a little direction. The below query correctly identifies the number of rows (count(*)) in the combined (Union) query. However, in addition to the number (count), I need to also display the Name (cn1.FullName) as there are multiple users. I have looked high and low for a similar example without success. I am not able to determine how to list the cn1.FullName within the query. I’m seeking a layout as follows –

[Open Notes] | [User]

and sorted by [Open Notes] asc

Any assistance would be greatly appreciated.

Thanks in advance,

Kcarey

Advertisement

Answer

Try:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement