SQL - how we can eliminate duplicates without using distinct command?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 159 of 168

how we can eliminate duplicates without using distinct command?

Total Answers and Comments: 3

Last Update: July 13, 2008 Asked by: Suganthidinesh

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 10, 2008 03:20:19

siripala

Member Since: May 2008 Contribution: 1

RE: how we can eliminate duplicates without using distinct command?

select column_with_duplicates, count(*) from table_name group by column_with_duplicates;

will give you distinct column values against number of ocurances

Is this answer useful? Yes | No

June 20, 2008 02:06:11

ashish88

Member Since: June 2008 Contribution: 8

RE: how we can eliminate duplicates without using distinct command?

select * from tale_name a where rowid >any(select rowid from table_name b where a.col1=b.col1)
this query show duplicate record ina table and use delete command to eleminate duplicate record in the table.

hope this helpful to you

Ashish Sharma

Is this answer useful? Yes | No

July 13, 2008 05:27:17

suresh.kurapati11

Member Since: July 2008 Contribution: 2

RE: how we can eliminate duplicates without using distinct command?

Use below query
select unique * from table_name;

Is this answer useful? Yes | No

Go To Top