2 Replies Latest reply: Mar 27, 2017 6:49 AM by Zied Ahmed RSS

    help scripting

    Zied Ahmed

      I would like to do a script like these in sql

      Number of cars

       

      SELECT * FROM Table WHERE Type = 'car' and date='17/01/01'

       

      --  Active cars

      SELECT DISTINCT (Machine) FROM Table WHERE Type= 'car ' and date='17/01/01'

       

      any suggestions please ?