SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
Wednesday, February 26, 2014
Find out the Duplicate records
Select
name
,
value
,
count
(*)
as
count
from
Employee
group
by
Name
,
value
having
count
(
name
)>
1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment