self join- how to use the aggregate functions
Posted
by Ranjana
on Stack Overflow
See other posts from Stack Overflow
or by Ranjana
Published on 2010-06-11T06:15:30Z
Indexed on
2010/06/11
6:22 UTC
Read the original article
Hit count: 537
self join- how to use the aggregate functions
select a.tablename,
b.TableName,b.UserName from Employee a inner join
Employee b on a.ColumnValue=b.ColumnValue
and and a.TableName <> b.TableName and
a.UserName=b.UserName
and also to check whether the same user has count of records i.e Employee a = count of records of Employee b.
how to add count function over here
© Stack Overflow or respective owner
