Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
SELECT FCode, NAVDate, NAVTime, COUNT(NAVTime) AS NumOccurrences FROM tblclassnav GROUP BY FCode, NAVDate, NAVTime HAVING ( COUNT(*) > 1 ) and navtime >= '1899-12-30 23:59:59.000'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL 2005 - Memory Table Column Names||11||81|
|Move SQL 2005 Express to Server 2012R2||19||168|
|Addition to SQL for dynamic fields||6||56|
|LAG_ROWID - how do I get the right order using this query?||2||22|