AF
HomeTagSubmit NotesAsk AnythingLoginSubscribe Us
AF
1. Feel Free to ask and submit anything on Anyforum.in and get satisfactory answer
2. Registration is not compulsory, you can directly login via google or facebook
3. Our Experts are looking for yours ?.



database-jdbc: How to remove duplicate records present in oracle database?

I have a employee data in my database. I want to remove duplicate records.

How to remove the duplicates using jdbc.

Could you please explain concept with example.

database x 10
jdbc x 32
Posted On : 2016-09-08 08:44:56.0
profile MOHAMMAD SALEEM BASHA - anyforum.in MOHAMMAD SALEEM BASHA
266150
up-rate
3
down-rate

Answers


If you want to select unique values from a single column use below query:

select unique column_name from table_name;

e.g.

select unique phone from employee;

and if you want to select unique rows use above query like this:

select unique * from employee;


Posted On : 2016-09-09 13:09:05
Satisfied : 1 Yes  0 No
profile Rishi Kumar - anyforum.in Rishi Kumar
523186220593
Reply This Thread
up-rate
3
down-rate



Post Answer
Please Login First to Post Answer: Login login with facebook - anyforum.in