MySQL Forums
Forum List  »  Newbie

Query Help
Posted by: Ravi S
Date: April 27, 2017 12:35AM

Hi All,


I am new to MySQL .I have data like this.

Action_ID InstanceID User ActionPerfomed BuildDate BuildID Appname
173 11111111 User1 running 3/23/2017 5:10 1 Application1
174 11111111 User1 restarted 3/23/2017 5:51 2 Application1
175 11111111 User2 running 3/23/2017 5:55 3 Application2
176 11111111 User2 stopped 3/23/2017 6:05 4 Application2
177 11111111 User1 running 3/23/2017 7:15 5 Application3
184 11111111 User1 stopped 3/23/2017 8:46 6 Application3


I want the output need to be like this.

InstanceID UserVZID BuildDate Hours ProjectName
11111111 User1 3/23/2017 0:00 3/23/2017 5:51-3/23/2017 5:10 Application1
11111111 User2 3/23/2017 0:00 3/23/2017 6:05-3/23/2017 5:55 Application2
11111111 User1 3/23/2017 0:00 3/23/2017 8:46-3/23/2017 7:15 Application3

Please help me to form the query.

Options: ReplyQuote


Subject
Written By
Posted
Query Help
April 27, 2017 12:35AM
April 27, 2017 09:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.