Stored Procedures

Results 1 to 2 of 2

Thread: Stored Procedures

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedures

    I have a table and when I do a simple "Select * From TableA" it gives me back <BR><BR>1<BR>1<BR>2<BR>3<BR>4<BR>5<BR>6<BR>6<BR>7< BR>7<BR>7<BR>8<BR><BR>How can I make it only give me back the records thate repeat like this.<BR><BR><BR>1<BR>1<BR>6<BR>6<BR>7<BR>7<BR>7<B R><BR><BR><BR>Bill Chapin

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedures

    SELECT theFieldName, COUNT(*) AS theCount FROM theTableName GROUP BY theFieldName HAVING theCount &#062; 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts