TechSapphire Monday, 2025-06-23, 11:27 PM
Main | | Registration | Login Welcome Guest | RSS
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
    		•
    Main » 2012 » September » 3 » Get duplicate record from table
    9:46 PM
    Get duplicate record from table
    Get duplicate records from table
    Select ename from tbemp a where a.eno!=(select Max(eno) from tbemp b where a.ename=b.ename)

    Here eno denotes to employee number and ename denotes to employee name.
    Category: Database | Views: 2405 | Added by: Admin | Tags: sqlserver, SQL, From, records, Duplicate, Get, Table, Name, server | Rating: 0.0/0
    Total comments: 0
    Only registered users can add comments.
    [ Registration | Login ]
    Categories
    Programming [27]
    Tips for programming
    Security [2]
    Security Tips
    Google [1]
    Use google faster then ever you use
    Project [14]
    HTML [2]
    Electronics [0]
    Data Structure [0]
    Database [16]
    SQL SERVER
    SSRS [1]
    Sql Server Reporting Services
    Copyright MyCorp © 2025