PrepAway - Latest Free Exam Questions & Answers

Which query will retrieve the names of all document owners and provide a count of the number of documents each

Which query will retrieve the names of all document owners and provide a count of the number of
documents each user owns?

PrepAway - Latest Free Exam Questions & Answers

A.
select “owner_name”, count(*) from “dm_document” group by “owner_name”

B.
select “owner_name”, count(*) from “dm_document” order by “owner_name”

C.
select “owner_name”, count(*) from “dm_document” having owner_name like ‘%’

D.
select distinct “owner_name”, count(*) from “dm_document”


Leave a Reply