How to get columns by SQL query?

Question

SQL

Hello everybody. Need help how to get specific columns for a query (on a specific date)? For example, I want to get all the columns (time) where the value is zero (typically free time) for this table. To whom it is not difficult to pay attention, thank you.

Answer 1

For example, I want to get all columns (time) where the value is zero (typically free time) for this table

if I understand the task correctly, and you want to conditionally form a list of columns dynamically (depending on the value of the column) - then the answer to your question is NO. In general, you have some strange database structure - it would be better if you reviewed it

Answer 2

where field=value
https://www.w3schools.com/sql/sql_where.asp