MySQL Forums
Forum List  »  Newbie

Re: Need to transform SQL query to MYSQL
Posted by: Alexandre Fraser
Date: February 24, 2016 02:38PM

In real my table have this still of info :

ipsentrylogsdate categorie description server status space1 ipsentrylogserver emplacement
2016-02-23 12:01:32 Hardware Hard Disk1 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 12:01:32 Hardware Hard Disk2 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 11:01:32 Hardware Hard Disk1 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 11:01:32 Hardware Hard Disk2 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 10:01:32 Hardware Hard Disk1 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 10:01:32 Hardware Hard Disk2 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 09:01:32 Hardware Hard Disk1 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)
2016-02-23 09:01:32 Hardware Hard Disk2 CSA12CTSRVSP701 OK 0 CSA12HDENVSP701 CSSS Alphonse-Desjardins (Levis)

I search to have a result for line with max date for each categorie, description, server

Options: ReplyQuote


Subject
Written By
Posted
Re: Need to transform SQL query to MYSQL
February 24, 2016 02:38PM


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.