Home > database >  SQL query
SQL query

Time:01-15

Existing a power outage information table, a CIRCUIT_NAME power lines, START_TIME outage start time, END_TIME blackouts over time, ORGNAME power substation, SPORGNAME city state company, PORGNAME area county, EQNM device name, DEV_POWER_CUT power equipment and other fields, line outage three times to query two months now and more than three times the power outage information, how to write the SQL? List specific fields is as follows:





To query results show as follows: