How to get duplicate rows if their any

Question

hi i have a table in oracle and a winform on front end (C#2005).

well problem is that i want to check if their is any duplication of rows based on four columns , if their is any duplication it wont let the user to see records or it should't pull up the records.

Note: i am selecting records where "transaction_date=?" the row has four columns that grouped together to make a composite key.

thanks in advance.

Bechir Bejaoui · Answer

To avoid duplicated rows you have to use the keyword Distinct within your SQL request if I well understood your question

Vijaya Kadiyala · Answer

HI Can you re-phrase your questions/requirement. Thanks Vijaya Kadiyala Http :// dotnetvj . blogspot . com

Lisa · Answer

write an SQL query to check if it has any such rows and assign an output parameter in the query to return back differently when you find data and when not then you can handle it on server side what to do based on the output parameter. Thanks Lisa