SQL Query Help Needed

Ignition
1

I don’t know if this can even be done. Maybe someone can help?

I want to query a SQL table, just 3 columns a (DateTime - BarrelTotal - Runtime)

But I need to create an “Alias Column” which is ( BarrelTotal / Runtime )

Can anyone provide or point me to how I can get this done?

Thanks

2

Select Datetime, BarrelTotal, Runtime, (BarrelTotal/Runtime) as MyTitle from DB.table_name
where xyz
order by abc

3 Likes
3

Thanks I will give it a try.