I am using nodejs, with express, mysql and js. I have a table called EVENT and one query im working on is to display only the data on the table that has the same start_time. Basically displaying all the data with conflicting start_time.
I tried a bunch of different queries but I cant manage to get it to work.
Any help would be appreciated.
db.query(
    'select start_time 
    FROM EVENT 
    INNER JOIN select start_time FROM EVENT GROUP BY start_time HAVING COUNT(EVENT > 1)', 
    function (err, result) {
      if (err) {
        res.status(500).send({error: true, message: "Error Querying Database"});
        // throw err;
      }
No comments:
Post a Comment