top of page
Search

SQL Queries #5 Fetch duplicate records

  • Prasanta Paul
  • Apr 30, 2018
  • 1 min read

QUERY TO FETCH DUPLICATE records..

Query:-

" Select empid, project,salary, Count(*) form sal GROUP BY empid,project, salary HAVING COUNT(*) >1"

[ For the table structure please visit sql query 1. ]

Recent Posts

See All
Selenium Java Concept 01

How to Call Web Driver System.SetProperty("WebDriver.Chrome.driver", "Path of the chrome driver"); WebDriver Driver = New Chrome...

 
 
 

Commenti

bottom of page