ziaguintu5
asked on
displaying only one
if the value of the table has 2 to 3 records that have the same value
how can i display it without repeating again
sample
DTR(table)
empid date1 timein type1
6111 9/10/2003 7:01 TI *TI stands for time in
6111 9/10/2003 7:01 TI
6111 9/1/2003 7:01 TI
6111 9/1/2003 5:10 TO *TO stands for time out
6111 9/1/2003 5:10 TO
6111 9/1/2003 5:10 TO
6111 9/1/2003 5:10 TO
6111 9/2/2003 7:10 TI
6111 9/2/2003 7:10 TI
how can i display it without repeating again
sample
DTR(table)
empid date1 timein type1
6111 9/10/2003 7:01 TI *TI stands for time in
6111 9/10/2003 7:01 TI
6111 9/1/2003 7:01 TI
6111 9/1/2003 5:10 TO *TO stands for time out
6111 9/1/2003 5:10 TO
6111 9/1/2003 5:10 TO
6111 9/1/2003 5:10 TO
6111 9/2/2003 7:10 TI
6111 9/2/2003 7:10 TI
Is this from a db, best to use your sql to filter out the dupes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with DoppyNL,
When updating your table with the information - have a query that checks to see if the data is in the table prior to you updating the table with the information. Its a little more in the code, but it will clean up your Database considerably.
Red010Knight
When updating your table with the information - have a query that checks to see if the data is in the table prior to you updating the table with the information. Its a little more in the code, but it will clean up your Database considerably.
Red010Knight
simple way use distinctinct keyword
select distinct * from table name
by using 'rowid' option in oracle we can delete the duplicate records