Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Repeated Data

This is a discussion on Repeated Data within the SQL forums, part of the Databases category; table:dept field: department values: sales sales marketing reporting revenue revenue how to get only the repeated data from the table...

Geeks Talk > Databases > SQL Repeated Data

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   03-28-2008

rahul.kgupta79 Junior Member   Join Date: Mar 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Repeated Data table:dept field: department values: sales sales marketing reporting revenue revenue how to get only the repeated data from the table

Sponsored Links

#2 (permalink)   03-29-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 64 Times in 63 Posts

Re: Repeated Data Quote: Originally Posted by rahul.kgupta79 table:dept field: department values: sales sales marketing reporting revenue revenue how to get only the repeated data from the table select department from dept where rowid in (select min(rowid) from dept group by department);

#3 (permalink)   04-01-2008

susarlasireesha Expert Member   Join Date: Apr 2007 Location: Bangalore Posts: 447 Thanks: 20 Thanked 54 Times in 54 Posts

Re: Repeated Data Quote: Originally Posted by rahul.kgupta79 table:dept field: department values: sales sales marketing reporting revenue revenue how to get only the repeated data from the table Try this select distinct department from dept where department in (select department from dept having count(*)>1 group by department)

Geeks Talk > Databases > SQL

« Employee and Department Query | view »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select unique elements from repeated elements	ImMadhumathi	AJAX & XML	0	03-03-2008 01:46 PM
Data Warehouse Bulk Data Transfer	Lokesh M	Data Warehousing	0	01-31-2008 06:52 AM
Extract Data from Operational Data sources Dynamically	Geek_Guest	Data Warehousing	0	07-22-2007 01:55 PM
How do we keep a track of a defect that is repeated	Geek_Guest	Testing Issues	7	07-11-2007 04:18 PM
Control file syntax to transfer data from multiple data files	Geek_Guest	Oracle Apps	0	06-14-2007 11:35 AM

All times are GMT -4. The time now is 10:47 AM.