SQL Select Question

Andrew21210

ADSM.ORG Member
Joined
Apr 10, 2008
Messages
97
Reaction score
2
Points
0
PREDATAR Control23

This may not be possible but I will post here before giving up. I am trying to find out the total number of mounts associated with a restore that I did awhile ago. Is it possible to build a select statement using the session id to get this info?
 
PREDATAR Control23

This should be enough to get you started.
Code:
select date(date_time) date, session, count(*) mounts from actlog where msgno=0510 group by date(date_time), session order by 1,2
 
Last edited by a moderator:
Top