help scripting

[zied_ahmed1]

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 ?

[vchuprina]

Hi Zied,

What do you want to use as data source (excel, txt, ...)?

[zied_ahmed1]

Hello i am connected to a database