I m trying to find some duplicate rows with the condition that duplicate row will have its time within 60 secs of original row...
But whn I ran query, I get error :
"Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
- Edited by Me.Saqib Wednesday, September 14, 2011 7:48 PM
Post DDL and the code. We cannot read your mind.
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL