Wednesday, September 4, 2013

Database FAQ's

Finding Non-unique rows.

SELECT LIC_NO, count(LIC_NO) AS cnt FROM LM_LICENSE GROUP BY LIC_NO HAVING cnt>1;
Posted by at

1 comment:

  1. Deepak BhagatAugust 20, 2018 at 5:40 PM

    SELECT LIC_NO, COUNT(LIC_NO) AS cnt FROM LM_LICENSE(nolock) GROUP BY LIC_NO HAVING COUNT(LIC_NO)>1;

    ReplyDelete

Subscribe to: Post Comments (Atom)