Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kapoor
  • Order by date
  1. kapoor

    selecting 1 instance of duplicate records

    Hi, Kujar This SQL query will give you the duplicate records in the particulat table: select * from <Tabname>a where rowid < ( select max(rowid) from <Tabname>b where b.location_nam = a.location_nam ) In case of any confusion feel free...

Part and Inventory Search

Back
Top Bottom