let the record be -
need help to write query to --
-- show duplicate record
-- do not show duplicate record
-- show only single record even for duplicate record
The query should work on any of the databases.
Plz do not use rowid,in clause , traversing through loop and checking the record or other reserved word which are not used in other databases.
performance and large number record should be considered.