Interview Questions  
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Go Back   Interview Questions > Interview Questions & Answers > Information Technology > Databases > SQL
Reload this Page How to find out the repeated value from table using groupby function

SQL SQL Interview Questions, Learn by sharing SQL Interview Questions asked in various Companies, Get Career advices, Interview Procedures from SQL experts, Post asked SQL Interview Questions and Answers.

   

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-19-2008, 02:10 PM
Senior Member
  
Join Date: Feb 2008
Posts: 1,046
Default How to find out the repeated value from table using groupby function



How to find out the repeated value from table using groupby function?
Reply With Quote
  #2 (permalink)  
Old 06-27-2008, 12:45 PM
Junior Member
  
Join Date: Jun 2008
Posts: 4
Default
with "having count(*)>1"
Reply With Quote
  #3 (permalink)  
Old 07-07-2008, 08:49 AM
Junior Member
  
Join Date: Jul 2008
Posts: 1
Exclamation
How to find out the repeated value from table using groupby function?
Reply With Quote
  #4 (permalink)  
Old 07-09-2008, 08:06 AM
Junior Member
  
Join Date: Jul 2008
Location: Delhi
Posts: 4
Send a message via Yahoo to koolswans
Default Hope it works for u...
select * from TableName group by FieldName having count(FieldName) > 1
Reply With Quote
Reply

Tags
database questions, servers questions, sql interview questions

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On








Contact Us - Interview Questions and Answers Discussion Community. - Archive - Top