select * from emp
group by (empid)
having count(empid)>1
--------------------------------------------------------------------------------
select * from emp where EmpID in(select EmpID
from emp
group by EmpID having count(EmpID)>1)
Subscribe to:
Post Comments (Atom)
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
-
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
No comments:
Post a Comment