| Forums.Sureshkumar.net : A Perfect Place to Share Knowledge Blogs Games Magazines |
|
|||||||
| SQL SQL Interview Questions asked in various Interviews. Professionals are invited to share Answers for these SQL Interview Questions. SQL Interview Questions with answers, Experiences, Career Advices, Tips and more. |
 |
|
|
LinkBack | Thread Tools | Rate Thread | Display Modes |
15-07-08, 06:30 PM
|
#2 (permalink) |
|
Junior Member
Join Date: Jul 2008
Posts: 26
Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1
|
Re: How to display duplicate rows in a table
select column1 from tablename
where column1<>0 group by column1 having count(*)>1
__________________
seemant Software Engineer |
|
    
|
|
| Tags |
| interview questions , sql |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated. | radhika_btech | Oracle Interview / Technical Questions | 2 | 19-09-08 03:05 PM |
| How to display duplicate rows in a table | shiva42 | SQL in Oracle | 0 | 12-06-08 06:35 PM |
| ORACLE placement paper 12 | sridhar | ORACLE Placement Papers | 0 | 09-02-07 07:23 PM |
| ORACLE placement paper 7 | sridhar | ORACLE Placement Papers | 0 | 09-02-07 06:44 PM |
| Sql - How to display duplicate rows in a table? | radhika_btech | Oracle Interview / Technical Questions | 1 | 28-01-07 02:07 AM |
Linear Mode
