delete duplicate rows

56 views

Skip to first unread message

nitesh dimri

unread,

Sep 4, 2012, 12:31:07 AM9/4/12

to oracle_db...@googlegroups.com

Sir,

Hello sir, can you please explain how to delete duplicate rows from the table...

Regards
Nitesh Dimri
Student

sabyasachi mishra

unread,

Sep 4, 2012, 3:26:19 AM9/4/12

to oracle_db...@googlegroups.com

hi nitesh dimri

you can use row id for this

delete from table_name where 
 rowid in ( select MAX(rowid) from tablename group by col1, col2, coln having count(1) > 1);

thanks

Ali Ismailov

unread,

Sep 4, 2012, 2:35:28 AM9/4/12

to oracle_db...@googlegroups.com

http://www.dba-oracle.com/t_delete_duplicate_table_rows.htm

2012/9/4 nitesh dimri <nites...@gmail.com>

Nitesh Dimri
Student

--
You received this message because you are subscribed to the Google Groups "ORACLE_DBA_EXPERTS" group.
To view this discussion on the web visit https://groups.google.com/d/msg/oracle_dba_experts/-/STF9nvcVyZ0J.
To post to this group, send email to oracle_db...@googlegroups.com.
To unsubscribe from this group, send email to oracle_dba_expe...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/oracle_dba_experts?hl=en.

--
Met vriendelijke groet,

Ali Ismailov

ddf

unread,

Sep 4, 2012, 10:21:18 AM9/4/12

to oracle_db...@googlegroups.com

Yet that doesn't work when more than two rows with the same data exist in a table;

SQL> select a, b, count(*)

2 from mydupes

3 group by a, b;

A B COUNT(*)

---------- -------------------- ----------

36 Test36 27

21 Test21 27

22 Test22 27

24 Test24 27

28 Test28 27

3 Test3 27

5 Test5 27

14 Test14 27

20 Test20 27

32 Test32 27

7 Test7 27

A B COUNT(*)

---------- -------------------- ----------

16 Test16 27

26 Test26 27

2 Test2 27

30 Test30 27

33 Test33 27

0 Test0 27

9 Test9 27

27 Test27 27

31 Test31 27

35 Test35 27

4 Test4 27

A B COUNT(*)

---------- -------------------- ----------

25 Test25 27

34 Test34 27

1 Test1 28

8 Test8 27

10 Test10 27

11 Test11 27

12 Test12 27

17 Test17 27

29 Test29 27

6 Test6 27

13 Test13 27

A B COUNT(*)

---------- -------------------- ----------

15 Test15 27

18 Test18 27

19 Test19 27

23 Test23 27

37 rows selected.

SQL>

SQL> delete from mydupes

2 where rowid in (select max(rowid)

3 from mydupes

4 group by a, b

5 having count(*) > 1);

37 rows deleted.

SQL>

SQL> select a, b, c

2 from mydupes;

A B C

---------- -------------------- --------------------

35 Test35 05-SEP-2012 00:12:13

36 Test36 05-SEP-2012 00:13:13

0 Test0 05-SEP-2012 00:14:13

1 Test1 05-SEP-2012 00:15:13

2 Test2 05-SEP-2012 00:16:13

3 Test3 05-SEP-2012 00:17:13

4 Test4 05-SEP-2012 00:18:13

5 Test5 05-SEP-2012 00:19:13

6 Test6 05-SEP-2012 00:20:13

7 Test7 05-SEP-2012 00:21:13

8 Test8 05-SEP-2012 00:22:13

A B C

---------- -------------------- --------------------

9 Test9 05-SEP-2012 00:23:13

10 Test10 05-SEP-2012 00:24:13

11 Test11 05-SEP-2012 00:25:13

12 Test12 05-SEP-2012 00:26:13

13 Test13 05-SEP-2012 00:27:13

14 Test14 05-SEP-2012 00:28:13

15 Test15 05-SEP-2012 00:29:13

16 Test16 05-SEP-2012 00:30:13

17 Test17 05-SEP-2012 00:31:13

18 Test18 05-SEP-2012 00:32:13

19 Test19 05-SEP-2012 00:33:13

A B C

---------- -------------------- --------------------

20 Test20 05-SEP-2012 00:34:13

21 Test21 05-SEP-2012 00:35:13

22 Test22 05-SEP-2012 00:36:13

23 Test23 05-SEP-2012 00:37:13

24 Test24 05-SEP-2012 00:38:13

25 Test25 05-SEP-2012 00:39:13

26 Test26 05-SEP-2012 00:40:13

27 Test27 05-SEP-2012 00:41:13

28 Test28 05-SEP-2012 00:42:13

29 Test29 05-SEP-2012 00:43:13

30 Test30 05-SEP-2012 00:44:13

A B C

---------- -------------------- --------------------

31 Test31 05-SEP-2012 00:45:13

32 Test32 05-SEP-2012 00:46:13

33 Test33 05-SEP-2012 00:47:13

34 Test34 05-SEP-2012 00:48:13

35 Test35 05-SEP-2012 00:49:13

36 Test36 05-SEP-2012 00:50:13

0 Test0 05-SEP-2012 00:51:13

1 Test1 05-SEP-2012 00:52:13

1 Test1 04-SEP-2012 08:13:13

2 Test2 04-SEP-2012 08:14:13

3 Test3 04-SEP-2012 08:15:13

A B C

---------- -------------------- --------------------

4 Test4 04-SEP-2012 08:16:13

5 Test5 04-SEP-2012 08:17:13

6 Test6 04-SEP-2012 08:18:13

7 Test7 04-SEP-2012 08:19:13

8 Test8 04-SEP-2012 08:20:13

9 Test9 04-SEP-2012 08:21:13

10 Test10 04-SEP-2012 08:22:13

11 Test11 04-SEP-2012 08:23:13

12 Test12 04-SEP-2012 08:24:13

13 Test13 04-SEP-2012 08:25:13

14 Test14 04-SEP-2012 08:26:13

A B C

---------- -------------------- --------------------

15 Test15 04-SEP-2012 08:27:13

16 Test16 04-SEP-2012 08:28:13

17 Test17 04-SEP-2012 08:29:13

18 Test18 04-SEP-2012 08:30:13

19 Test19 04-SEP-2012 08:31:13

20 Test20 04-SEP-2012 08:32:13

21 Test21 04-SEP-2012 08:33:13

22 Test22 04-SEP-2012 08:34:13

23 Test23 04-SEP-2012 08:35:13

24 Test24 04-SEP-2012 08:36:13

25 Test25 04-SEP-2012 08:37:13

A B C

---------- -------------------- --------------------

26 Test26 04-SEP-2012 08:38:13

27 Test27 04-SEP-2012 08:39:13

28 Test28 04-SEP-2012 08:40:13

29 Test29 04-SEP-2012 08:41:13

30 Test30 04-SEP-2012 08:42:13

31 Test31 04-SEP-2012 08:43:13

32 Test32 04-SEP-2012 08:44:13

33 Test33 04-SEP-2012 08:45:13

34 Test34 04-SEP-2012 08:46:13

35 Test35 04-SEP-2012 08:47:13

36 Test36 04-SEP-2012 08:48:13

A B C

---------- -------------------- --------------------

0 Test0 04-SEP-2012 08:49:13

1 Test1 04-SEP-2012 08:50:13

2 Test2 04-SEP-2012 08:51:13

3 Test3 04-SEP-2012 08:52:13

4 Test4 04-SEP-2012 08:53:13

5 Test5 04-SEP-2012 08:54:13

6 Test6 04-SEP-2012 08:55:13

7 Test7 04-SEP-2012 08:56:13

8 Test8 04-SEP-2012 08:57:13

9 Test9 04-SEP-2012 08:58:13

10 Test10 04-SEP-2012 08:59:13

A B C

---------- -------------------- --------------------

11 Test11 04-SEP-2012 09:00:13

12 Test12 04-SEP-2012 09:01:13

13 Test13 04-SEP-2012 09:02:13

14 Test14 04-SEP-2012 09:03:13

15 Test15 04-SEP-2012 09:04:13

16 Test16 04-SEP-2012 09:05:13

17 Test17 04-SEP-2012 09:06:13

18 Test18 04-SEP-2012 09:07:13

19 Test19 04-SEP-2012 09:08:13

20 Test20 04-SEP-2012 09:09:13

21 Test21 04-SEP-2012 09:10:13

A B C

---------- -------------------- --------------------

22 Test22 04-SEP-2012 09:11:13

23 Test23 04-SEP-2012 09:12:13

24 Test24 04-SEP-2012 09:13:13

25 Test25 04-SEP-2012 09:14:13

26 Test26 04-SEP-2012 09:15:13

27 Test27 04-SEP-2012 09:16:13

28 Test28 04-SEP-2012 09:17:13

29 Test29 04-SEP-2012 09:18:13

30 Test30 04-SEP-2012 09:19:13

31 Test31 04-SEP-2012 09:20:13

32 Test32 04-SEP-2012 09:21:13

A B C

---------- -------------------- --------------------

33 Test33 04-SEP-2012 09:22:13

34 Test34 04-SEP-2012 09:23:13

35 Test35 04-SEP-2012 09:24:13

36 Test36 04-SEP-2012 09:25:13

0 Test0 04-SEP-2012 09:26:13

1 Test1 04-SEP-2012 09:27:13

2 Test2 04-SEP-2012 09:28:13

3 Test3 04-SEP-2012 09:29:13

4 Test4 04-SEP-2012 09:30:13

5 Test5 04-SEP-2012 09:31:13

6 Test6 04-SEP-2012 09:32:13

A B C

---------- -------------------- --------------------

7 Test7 04-SEP-2012 09:33:13

8 Test8 04-SEP-2012 09:34:13

9 Test9 04-SEP-2012 09:35:13

10 Test10 04-SEP-2012 09:36:13

11 Test11 04-SEP-2012 09:37:13

12 Test12 04-SEP-2012 09:38:13

13 Test13 04-SEP-2012 09:39:13

14 Test14 04-SEP-2012 09:40:13

15 Test15 04-SEP-2012 09:41:13

16 Test16 04-SEP-2012 09:42:13

17 Test17 04-SEP-2012 09:43:13

A B C

---------- -------------------- --------------------

18 Test18 04-SEP-2012 09:44:13

19 Test19 04-SEP-2012 09:45:13

20 Test20 04-SEP-2012 09:46:13

21 Test21 04-SEP-2012 09:47:13

22 Test22 04-SEP-2012 09:48:13

23 Test23 04-SEP-2012 09:49:13

24 Test24 04-SEP-2012 09:50:13

25 Test25 04-SEP-2012 09:51:13

26 Test26 04-SEP-2012 09:52:13

27 Test27 04-SEP-2012 09:53:13

28 Test28 04-SEP-2012 09:54:13

A B C

---------- -------------------- --------------------

29 Test29 04-SEP-2012 09:55:13

30 Test30 04-SEP-2012 09:56:13

31 Test31 04-SEP-2012 09:57:13

32 Test32 04-SEP-2012 09:58:13

33 Test33 04-SEP-2012 09:59:13

34 Test34 04-SEP-2012 10:00:13

35 Test35 04-SEP-2012 10:01:13

36 Test36 04-SEP-2012 10:02:13

0 Test0 04-SEP-2012 10:03:13

1 Test1 04-SEP-2012 10:04:13

2 Test2 04-SEP-2012 10:05:13

A B C

---------- -------------------- --------------------

3 Test3 04-SEP-2012 10:06:13

4 Test4 04-SEP-2012 10:07:13

5 Test5 04-SEP-2012 10:08:13

6 Test6 04-SEP-2012 10:09:13

7 Test7 04-SEP-2012 10:10:13

8 Test8 04-SEP-2012 10:11:13

9 Test9 04-SEP-2012 10:12:13

10 Test10 04-SEP-2012 10:13:13

11 Test11 04-SEP-2012 10:14:13

12 Test12 04-SEP-2012 10:15:13

13 Test13 04-SEP-2012 10:16:13

A B C

---------- -------------------- --------------------

14 Test14 04-SEP-2012 10:17:13

15 Test15 04-SEP-2012 10:18:13

16 Test16 04-SEP-2012 10:19:13

17 Test17 04-SEP-2012 10:20:13

18 Test18 04-SEP-2012 10:21:13

19 Test19 04-SEP-2012 10:22:13

20 Test20 04-SEP-2012 10:23:13

21 Test21 04-SEP-2012 10:24:13

22 Test22 04-SEP-2012 10:25:13

23 Test23 04-SEP-2012 10:26:13

24 Test24 04-SEP-2012 10:27:13

A B C

---------- -------------------- --------------------

25 Test25 04-SEP-2012 10:28:13

26 Test26 04-SEP-2012 10:29:13

27 Test27 04-SEP-2012 10:30:13

28 Test28 04-SEP-2012 10:31:13

29 Test29 04-SEP-2012 10:32:13

30 Test30 04-SEP-2012 10:33:13

31 Test31 04-SEP-2012 10:34:13

32 Test32 04-SEP-2012 10:35:13

33 Test33 04-SEP-2012 10:36:13

34 Test34 04-SEP-2012 10:37:13

35 Test35 04-SEP-2012 10:38:13

A B C

---------- -------------------- --------------------

36 Test36 04-SEP-2012 10:39:13

0 Test0 04-SEP-2012 10:40:13

1 Test1 04-SEP-2012 10:41:13

2 Test2 04-SEP-2012 10:42:13

3 Test3 04-SEP-2012 10:43:13

4 Test4 04-SEP-2012 10:44:13

5 Test5 04-SEP-2012 10:45:13

6 Test6 04-SEP-2012 10:46:13

7 Test7 04-SEP-2012 10:47:13

8 Test8 04-SEP-2012 10:48:13

9 Test9 04-SEP-2012 10:49:13

A B C

---------- -------------------- --------------------

10 Test10 04-SEP-2012 10:50:13

11 Test11 04-SEP-2012 10:51:13

12 Test12 04-SEP-2012 10:52:13

13 Test13 04-SEP-2012 10:53:13

14 Test14 04-SEP-2012 10:54:13

15 Test15 04-SEP-2012 10:55:13

16 Test16 04-SEP-2012 10:56:13

17 Test17 04-SEP-2012 10:57:13

18 Test18 04-SEP-2012 10:58:13

19 Test19 04-SEP-2012 10:59:13

20 Test20 04-SEP-2012 11:00:13

A B C

---------- -------------------- --------------------

21 Test21 04-SEP-2012 11:01:13

22 Test22 04-SEP-2012 11:02:13

23 Test23 04-SEP-2012 11:03:13

24 Test24 04-SEP-2012 11:04:13

25 Test25 04-SEP-2012 11:05:13

26 Test26 04-SEP-2012 11:06:13

27 Test27 04-SEP-2012 11:07:13

28 Test28 04-SEP-2012 11:08:13

29 Test29 04-SEP-2012 11:09:13

30 Test30 04-SEP-2012 11:10:13

31 Test31 04-SEP-2012 11:11:13

A B C

---------- -------------------- --------------------

32 Test32 04-SEP-2012 11:12:13

33 Test33 04-SEP-2012 11:13:13

34 Test34 04-SEP-2012 11:14:13

35 Test35 04-SEP-2012 11:15:13

36 Test36 04-SEP-2012 11:16:13

0 Test0 04-SEP-2012 11:17:13

1 Test1 04-SEP-2012 11:18:13

2 Test2 04-SEP-2012 11:19:13

3 Test3 04-SEP-2012 11:20:13

4 Test4 04-SEP-2012 11:21:13

5 Test5 04-SEP-2012 11:22:13

A B C

---------- -------------------- --------------------

6 Test6 04-SEP-2012 11:23:13

7 Test7 04-SEP-2012 11:24:13

8 Test8 04-SEP-2012 11:25:13

9 Test9 04-SEP-2012 11:26:13

10 Test10 04-SEP-2012 11:27:13

11 Test11 04-SEP-2012 11:28:13

12 Test12 04-SEP-2012 11:29:13

13 Test13 04-SEP-2012 11:30:13

14 Test14 04-SEP-2012 11:31:13

15 Test15 04-SEP-2012 11:32:13

16 Test16 04-SEP-2012 11:33:13

A B C

---------- -------------------- --------------------

17 Test17 04-SEP-2012 11:34:13

18 Test18 04-SEP-2012 11:35:13

19 Test19 04-SEP-2012 11:36:13

20 Test20 04-SEP-2012 11:37:13

21 Test21 04-SEP-2012 11:38:13

22 Test22 04-SEP-2012 11:39:13

23 Test23 04-SEP-2012 11:40:13

24 Test24 04-SEP-2012 11:41:13

25 Test25 04-SEP-2012 11:42:13

26 Test26 04-SEP-2012 11:43:13

27 Test27 04-SEP-2012 11:44:13

A B C

---------- -------------------- --------------------

28 Test28 04-SEP-2012 11:45:13

29 Test29 04-SEP-2012 11:46:13

30 Test30 04-SEP-2012 11:47:13

31 Test31 04-SEP-2012 11:48:13

32 Test32 04-SEP-2012 11:49:13

33 Test33 04-SEP-2012 11:50:13

34 Test34 04-SEP-2012 11:51:13

35 Test35 04-SEP-2012 11:52:13

36 Test36 04-SEP-2012 11:53:13

0 Test0 04-SEP-2012 11:54:13

1 Test1 04-SEP-2012 11:55:13

A B C

---------- -------------------- --------------------

2 Test2 04-SEP-2012 11:56:13

3 Test3 04-SEP-2012 11:57:13

4 Test4 04-SEP-2012 11:58:13

5 Test5 04-SEP-2012 11:59:13

6 Test6 04-SEP-2012 12:00:13

7 Test7 04-SEP-2012 12:01:13

8 Test8 04-SEP-2012 12:02:13

9 Test9 04-SEP-2012 12:03:13

10 Test10 04-SEP-2012 12:04:13

11 Test11 04-SEP-2012 12:05:13

12 Test12 04-SEP-2012 12:06:13

A B C

---------- -------------------- --------------------

13 Test13 04-SEP-2012 12:07:13

14 Test14 04-SEP-2012 12:08:13

15 Test15 04-SEP-2012 12:09:13

16 Test16 04-SEP-2012 12:10:13

17 Test17 04-SEP-2012 12:11:13

18 Test18 04-SEP-2012 12:12:13

19 Test19 04-SEP-2012 12:13:13

20 Test20 04-SEP-2012 12:14:13

21 Test21 04-SEP-2012 12:15:13

22 Test22 04-SEP-2012 12:16:13

23 Test23 04-SEP-2012 12:17:13

A B C

---------- -------------------- --------------------

24 Test24 04-SEP-2012 12:18:13

25 Test25 04-SEP-2012 12:19:13

26 Test26 04-SEP-2012 12:20:13

27 Test27 04-SEP-2012 12:21:13

28 Test28 04-SEP-2012 12:22:13

29 Test29 04-SEP-2012 12:23:13

30 Test30 04-SEP-2012 12:24:13

31 Test31 04-SEP-2012 12:25:13

32 Test32 04-SEP-2012 12:26:13

33 Test33 04-SEP-2012 12:27:13

34 Test34 04-SEP-2012 12:28:13

A B C

---------- -------------------- --------------------

35 Test35 04-SEP-2012 12:29:13

36 Test36 04-SEP-2012 12:30:13

0 Test0 04-SEP-2012 12:31:13

1 Test1 04-SEP-2012 12:32:13

2 Test2 04-SEP-2012 12:33:13

3 Test3 04-SEP-2012 12:34:13

4 Test4 04-SEP-2012 12:35:13

5 Test5 04-SEP-2012 12:36:13

6 Test6 04-SEP-2012 12:37:13

7 Test7 04-SEP-2012 12:38:13

8 Test8 04-SEP-2012 12:39:13

A B C

---------- -------------------- --------------------

9 Test9 04-SEP-2012 12:40:13

10 Test10 04-SEP-2012 12:41:13

11 Test11 04-SEP-2012 12:42:13

12 Test12 04-SEP-2012 12:43:13

13 Test13 04-SEP-2012 12:44:13

14 Test14 04-SEP-2012 12:45:13

15 Test15 04-SEP-2012 12:46:13

16 Test16 04-SEP-2012 12:47:13

17 Test17 04-SEP-2012 12:48:13

18 Test18 04-SEP-2012 12:49:13

19 Test19 04-SEP-2012 12:50:13

A B C

---------- -------------------- --------------------

20 Test20 04-SEP-2012 12:51:13

21 Test21 04-SEP-2012 12:52:13

22 Test22 04-SEP-2012 12:53:13

23 Test23 04-SEP-2012 12:54:13

24 Test24 04-SEP-2012 12:55:13

25 Test25 04-SEP-2012 12:56:13

26 Test26 04-SEP-2012 12:57:13

27 Test27 04-SEP-2012 12:58:13

28 Test28 04-SEP-2012 12:59:13

29 Test29 04-SEP-2012 13:00:13

30 Test30 04-SEP-2012 13:01:13

A B C

---------- -------------------- --------------------

31 Test31 04-SEP-2012 13:02:13

32 Test32 04-SEP-2012 13:03:13

33 Test33 04-SEP-2012 13:04:13

34 Test34 04-SEP-2012 13:05:13

35 Test35 04-SEP-2012 13:06:13

36 Test36 04-SEP-2012 13:07:13

0 Test0 04-SEP-2012 13:08:13

1 Test1 04-SEP-2012 13:09:13

2 Test2 04-SEP-2012 13:10:13

3 Test3 04-SEP-2012 13:11:13

4 Test4 04-SEP-2012 13:12:13

A B C

---------- -------------------- --------------------

5 Test5 04-SEP-2012 13:13:13

6 Test6 04-SEP-2012 13:14:13

7 Test7 04-SEP-2012 13:15:13

8 Test8 04-SEP-2012 13:16:13

9 Test9 04-SEP-2012 13:17:13

10 Test10 04-SEP-2012 13:18:13

11 Test11 04-SEP-2012 13:19:13

12 Test12 04-SEP-2012 13:20:13

13 Test13 04-SEP-2012 13:21:13

14 Test14 04-SEP-2012 13:22:13

15 Test15 04-SEP-2012 13:23:13

A B C

---------- -------------------- --------------------

16 Test16 04-SEP-2012 13:24:13

17 Test17 04-SEP-2012 13:25:13

18 Test18 04-SEP-2012 13:26:13

19 Test19 04-SEP-2012 13:27:13

20 Test20 04-SEP-2012 13:28:13

21 Test21 04-SEP-2012 13:29:13

22 Test22 04-SEP-2012 13:30:13

23 Test23 04-SEP-2012 13:31:13

24 Test24 04-SEP-2012 13:32:13

25 Test25 04-SEP-2012 13:33:13

26 Test26 04-SEP-2012 13:34:13

A B C

---------- -------------------- --------------------

27 Test27 04-SEP-2012 13:35:13

28 Test28 04-SEP-2012 13:36:13

29 Test29 04-SEP-2012 13:37:13

30 Test30 04-SEP-2012 13:38:13

31 Test31 04-SEP-2012 13:39:13

32 Test32 04-SEP-2012 13:40:13

33 Test33 04-SEP-2012 13:41:13

34 Test34 04-SEP-2012 13:42:13

35 Test35 04-SEP-2012 13:43:13

36 Test36 04-SEP-2012 13:44:13

0 Test0 04-SEP-2012 13:45:13

A B C

---------- -------------------- --------------------

1 Test1 04-SEP-2012 13:46:13

2 Test2 04-SEP-2012 13:47:13

3 Test3 04-SEP-2012 13:48:13

4 Test4 04-SEP-2012 13:49:13

5 Test5 04-SEP-2012 13:50:13

6 Test6 04-SEP-2012 13:51:13

7 Test7 04-SEP-2012 13:52:13

8 Test8 04-SEP-2012 13:53:13

9 Test9 04-SEP-2012 13:54:13

10 Test10 04-SEP-2012 13:55:13

11 Test11 04-SEP-2012 13:56:13

A B C

---------- -------------------- --------------------

12 Test12 04-SEP-2012 13:57:13

13 Test13 04-SEP-2012 13:58:13

14 Test14 04-SEP-2012 13:59:13

15 Test15 04-SEP-2012 14:00:13

16 Test16 04-SEP-2012 14:01:13

17 Test17 04-SEP-2012 14:02:13

18 Test18 04-SEP-2012 14:03:13

19 Test19 04-SEP-2012 14:04:13

20 Test20 04-SEP-2012 14:05:13

21 Test21 04-SEP-2012 14:06:13

22 Test22 04-SEP-2012 14:07:13

A B C

---------- -------------------- --------------------

23 Test23 04-SEP-2012 14:08:13

24 Test24 04-SEP-2012 14:09:13

25 Test25 04-SEP-2012 14:10:13

26 Test26 04-SEP-2012 14:11:13

27 Test27 04-SEP-2012 14:12:13

28 Test28 04-SEP-2012 14:13:13

29 Test29 04-SEP-2012 14:14:13

30 Test30 04-SEP-2012 14:15:13

31 Test31 04-SEP-2012 14:16:13

32 Test32 04-SEP-2012 14:17:13

33 Test33 04-SEP-2012 14:18:13

A B C

---------- -------------------- --------------------

34 Test34 04-SEP-2012 14:19:13

35 Test35 04-SEP-2012 14:20:13

36 Test36 04-SEP-2012 14:21:13

0 Test0 04-SEP-2012 14:22:13

1 Test1 04-SEP-2012 14:23:13

2 Test2 04-SEP-2012 14:24:13

3 Test3 04-SEP-2012 14:25:13

4 Test4 04-SEP-2012 14:26:13

5 Test5 04-SEP-2012 14:27:13

6 Test6 04-SEP-2012 14:28:13

7 Test7 04-SEP-2012 14:29:13

A B C

---------- -------------------- --------------------

8 Test8 04-SEP-2012 14:30:13

9 Test9 04-SEP-2012 14:31:13

10 Test10 04-SEP-2012 14:32:13

11 Test11 04-SEP-2012 14:33:13

12 Test12 04-SEP-2012 14:34:13

13 Test13 04-SEP-2012 14:35:13

14 Test14 04-SEP-2012 14:36:13

15 Test15 04-SEP-2012 14:37:13

16 Test16 04-SEP-2012 14:38:13

17 Test17 04-SEP-2012 14:39:13

18 Test18 04-SEP-2012 14:40:13

A B C

---------- -------------------- --------------------

19 Test19 04-SEP-2012 14:41:13

20 Test20 04-SEP-2012 14:42:13

21 Test21 04-SEP-2012 14:43:13

22 Test22 04-SEP-2012 14:44:13

23 Test23 04-SEP-2012 14:45:13

24 Test24 04-SEP-2012 14:46:13

25 Test25 04-SEP-2012 14:47:13

26 Test26 04-SEP-2012 14:48:13

27 Test27 04-SEP-2012 14:49:13

28 Test28 04-SEP-2012 14:50:13

29 Test29 04-SEP-2012 14:51:13

A B C

---------- -------------------- --------------------

30 Test30 04-SEP-2012 14:52:13

31 Test31 04-SEP-2012 14:53:13

32 Test32 04-SEP-2012 14:54:13

33 Test33 04-SEP-2012 14:55:13

34 Test34 04-SEP-2012 14:56:13

35 Test35 04-SEP-2012 14:57:13

36 Test36 04-SEP-2012 14:58:13

0 Test0 04-SEP-2012 14:59:13

1 Test1 04-SEP-2012 15:00:13

2 Test2 04-SEP-2012 15:01:13

3 Test3 04-SEP-2012 15:02:13

A B C

---------- -------------------- --------------------

4 Test4 04-SEP-2012 15:03:13

5 Test5 04-SEP-2012 15:04:13

6 Test6 04-SEP-2012 15:05:13

7 Test7 04-SEP-2012 15:06:13

8 Test8 04-SEP-2012 15:07:13

9 Test9 04-SEP-2012 15:08:13

10 Test10 04-SEP-2012 15:09:13

11 Test11 04-SEP-2012 15:10:13

12 Test12 04-SEP-2012 15:11:13

13 Test13 04-SEP-2012 15:12:13

14 Test14 04-SEP-2012 15:13:13

A B C

---------- -------------------- --------------------

15 Test15 04-SEP-2012 15:14:13

16 Test16 04-SEP-2012 15:15:13

17 Test17 04-SEP-2012 15:16:13

18 Test18 04-SEP-2012 15:17:13

19 Test19 04-SEP-2012 15:18:13

20 Test20 04-SEP-2012 15:19:13

21 Test21 04-SEP-2012 15:20:13

22 Test22 04-SEP-2012 15:21:13

23 Test23 04-SEP-2012 15:22:13

24 Test24 04-SEP-2012 15:23:13

25 Test25 04-SEP-2012 15:24:13

A B C

---------- -------------------- --------------------

26 Test26 04-SEP-2012 15:25:13

27 Test27 04-SEP-2012 15:26:13

28 Test28 04-SEP-2012 15:27:13

29 Test29 04-SEP-2012 15:28:13

30 Test30 04-SEP-2012 15:29:13

31 Test31 04-SEP-2012 15:30:13

32 Test32 04-SEP-2012 15:31:13

33 Test33 04-SEP-2012 15:32:13

34 Test34 04-SEP-2012 15:33:13

35 Test35 04-SEP-2012 15:34:13

36 Test36 04-SEP-2012 15:35:13

A B C

---------- -------------------- --------------------

0 Test0 04-SEP-2012 15:36:13

1 Test1 04-SEP-2012 15:37:13

2 Test2 04-SEP-2012 15:38:13

3 Test3 04-SEP-2012 15:39:13

4 Test4 04-SEP-2012 15:40:13

5 Test5 04-SEP-2012 15:41:13

6 Test6 04-SEP-2012 15:42:13

7 Test7 04-SEP-2012 15:43:13

8 Test8 04-SEP-2012 15:44:13

9 Test9 04-SEP-2012 15:45:13

10 Test10 04-SEP-2012 15:46:13

A B C

---------- -------------------- --------------------

11 Test11 04-SEP-2012 15:47:13

12 Test12 04-SEP-2012 15:48:13

13 Test13 04-SEP-2012 15:49:13

14 Test14 04-SEP-2012 15:50:13

15 Test15 04-SEP-2012 15:51:13

16 Test16 04-SEP-2012 15:52:13

17 Test17 04-SEP-2012 15:53:13

18 Test18 04-SEP-2012 15:54:13

19 Test19 04-SEP-2012 15:55:13

20 Test20 04-SEP-2012 15:56:13

21 Test21 04-SEP-2012 15:57:13

A B C

---------- -------------------- --------------------

22 Test22 04-SEP-2012 15:58:13

23 Test23 04-SEP-2012 15:59:13

24 Test24 04-SEP-2012 16:00:13

25 Test25 04-SEP-2012 16:01:13

26 Test26 04-SEP-2012 16:02:13

27 Test27 04-SEP-2012 16:03:13

28 Test28 04-SEP-2012 16:04:13

29 Test29 04-SEP-2012 16:05:13

30 Test30 04-SEP-2012 16:06:13

31 Test31 04-SEP-2012 16:07:13

32 Test32 04-SEP-2012 16:08:13

A B C

---------- -------------------- --------------------

33 Test33 04-SEP-2012 16:09:13

34 Test34 04-SEP-2012 16:10:13

35 Test35 04-SEP-2012 16:11:13

36 Test36 04-SEP-2012 16:12:13

0 Test0 04-SEP-2012 16:13:13

1 Test1 04-SEP-2012 16:14:13

2 Test2 04-SEP-2012 16:15:13

3 Test3 04-SEP-2012 16:16:13

4 Test4 04-SEP-2012 16:17:13

5 Test5 04-SEP-2012 16:18:13

6 Test6 04-SEP-2012 16:19:13

A B C

---------- -------------------- --------------------

7 Test7 04-SEP-2012 16:20:13

8 Test8 04-SEP-2012 16:21:13

9 Test9 04-SEP-2012 16:22:13

10 Test10 04-SEP-2012 16:23:13

11 Test11 04-SEP-2012 16:24:13

12 Test12 04-SEP-2012 16:25:13

13 Test13 04-SEP-2012 16:26:13

14 Test14 04-SEP-2012 16:27:13

15 Test15 04-SEP-2012 16:28:13

16 Test16 04-SEP-2012 16:29:13

17 Test17 04-SEP-2012 16:30:13

A B C

---------- -------------------- --------------------

18 Test18 04-SEP-2012 16:31:13

19 Test19 04-SEP-2012 16:32:13

20 Test20 04-SEP-2012 16:33:13

21 Test21 04-SEP-2012 16:34:13

22 Test22 04-SEP-2012 16:35:13

23 Test23 04-SEP-2012 16:36:13

24 Test24 04-SEP-2012 16:37:13

25 Test25 04-SEP-2012 16:38:13

26 Test26 04-SEP-2012 16:39:13

27 Test27 04-SEP-2012 16:40:13

28 Test28 04-SEP-2012 16:41:13

A B C

---------- -------------------- --------------------

29 Test29 04-SEP-2012 16:42:13

30 Test30 04-SEP-2012 16:43:13

31 Test31 04-SEP-2012 16:44:13

32 Test32 04-SEP-2012 16:45:13

33 Test33 04-SEP-2012 16:46:13

34 Test34 04-SEP-2012 16:47:13

35 Test35 04-SEP-2012 16:48:13

36 Test36 04-SEP-2012 16:49:13

0 Test0 04-SEP-2012 16:50:13

1 Test1 04-SEP-2012 16:51:13

2 Test2 04-SEP-2012 16:52:13

A B C

---------- -------------------- --------------------

3 Test3 04-SEP-2012 16:53:13

4 Test4 04-SEP-2012 16:54:13

5 Test5 04-SEP-2012 16:55:13

6 Test6 04-SEP-2012 16:56:13

7 Test7 04-SEP-2012 16:57:13

8 Test8 04-SEP-2012 16:58:13

9 Test9 04-SEP-2012 16:59:13

10 Test10 04-SEP-2012 17:00:13

11 Test11 04-SEP-2012 17:01:13

12 Test12 04-SEP-2012 17:02:13

13 Test13 04-SEP-2012 17:03:13

A B C

---------- -------------------- --------------------

14 Test14 04-SEP-2012 17:04:13

15 Test15 04-SEP-2012 17:05:13

16 Test16 04-SEP-2012 17:06:13

17 Test17 04-SEP-2012 17:07:13

18 Test18 04-SEP-2012 17:08:13

19 Test19 04-SEP-2012 17:09:13

20 Test20 04-SEP-2012 17:10:13

21 Test21 04-SEP-2012 17:11:13

22 Test22 04-SEP-2012 17:12:13

23 Test23 04-SEP-2012 17:13:13

24 Test24 04-SEP-2012 17:14:13

A B C

---------- -------------------- --------------------

25 Test25 04-SEP-2012 17:15:13

26 Test26 04-SEP-2012 17:16:13

27 Test27 04-SEP-2012 17:17:13

28 Test28 04-SEP-2012 17:18:13

29 Test29 04-SEP-2012 17:19:13

30 Test30 04-SEP-2012 17:20:13

31 Test31 04-SEP-2012 17:21:13

32 Test32 04-SEP-2012 17:22:13

33 Test33 04-SEP-2012 17:23:13

34 Test34 04-SEP-2012 17:24:13

35 Test35 04-SEP-2012 17:25:13

A B C

---------- -------------------- --------------------

36 Test36 04-SEP-2012 17:26:13

0 Test0 04-SEP-2012 17:27:13

1 Test1 04-SEP-2012 17:28:13

2 Test2 04-SEP-2012 17:29:13

3 Test3 04-SEP-2012 17:30:13

4 Test4 04-SEP-2012 17:31:13

5 Test5 04-SEP-2012 17:32:13

6 Test6 04-SEP-2012 17:33:13

7 Test7 04-SEP-2012 17:34:13

8 Test8 04-SEP-2012 17:35:13

9 Test9 04-SEP-2012 17:36:13

A B C

---------- -------------------- --------------------

10 Test10 04-SEP-2012 17:37:13

11 Test11 04-SEP-2012 17:38:13

12 Test12 04-SEP-2012 17:39:13

13 Test13 04-SEP-2012 17:40:13

14 Test14 04-SEP-2012 17:41:13

15 Test15 04-SEP-2012 17:42:13

16 Test16 04-SEP-2012 17:43:13

17 Test17 04-SEP-2012 17:44:13

18 Test18 04-SEP-2012 17:45:13

19 Test19 04-SEP-2012 17:46:13

20 Test20 04-SEP-2012 17:47:13

A B C

---------- -------------------- --------------------

21 Test21 04-SEP-2012 17:48:13

22 Test22 04-SEP-2012 17:49:13

23 Test23 04-SEP-2012 17:50:13

24 Test24 04-SEP-2012 17:51:13

25 Test25 04-SEP-2012 17:52:13

26 Test26 04-SEP-2012 17:53:13

27 Test27 04-SEP-2012 17:54:13

28 Test28 04-SEP-2012 17:55:13

29 Test29 04-SEP-2012 17:56:13

30 Test30 04-SEP-2012 17:57:13

31 Test31 04-SEP-2012 17:58:13

A B C

---------- -------------------- --------------------

32 Test32 04-SEP-2012 17:59:13

33 Test33 04-SEP-2012 18:00:13

34 Test34 04-SEP-2012 18:01:13

35 Test35 04-SEP-2012 18:02:13

36 Test36 04-SEP-2012 18:03:13

0 Test0 04-SEP-2012 18:04:13

1 Test1 04-SEP-2012 18:05:13

2 Test2 04-SEP-2012 18:06:13

3 Test3 04-SEP-2012 18:07:13

4 Test4 04-SEP-2012 18:08:13

5 Test5 04-SEP-2012 18:09:13

A B C

---------- -------------------- --------------------

6 Test6 04-SEP-2012 18:10:13

7 Test7 04-SEP-2012 18:11:13

8 Test8 04-SEP-2012 18:12:13

9 Test9 04-SEP-2012 18:13:13

10 Test10 04-SEP-2012 18:14:13

11 Test11 04-SEP-2012 18:15:13

12 Test12 04-SEP-2012 18:16:13

13 Test13 04-SEP-2012 18:17:13

14 Test14 04-SEP-2012 18:18:13

15 Test15 04-SEP-2012 18:19:13

16 Test16 04-SEP-2012 18:20:13

A B C

---------- -------------------- --------------------

17 Test17 04-SEP-2012 18:21:13

18 Test18 04-SEP-2012 18:22:13

19 Test19 04-SEP-2012 18:23:13

20 Test20 04-SEP-2012 18:24:13

21 Test21 04-SEP-2012 18:25:13

22 Test22 04-SEP-2012 18:26:13

23 Test23 04-SEP-2012 18:27:13

24 Test24 04-SEP-2012 18:28:13

25 Test25 04-SEP-2012 18:29:13

26 Test26 04-SEP-2012 18:30:13

27 Test27 04-SEP-2012 18:31:13

A B C

---------- -------------------- --------------------

28 Test28 04-SEP-2012 18:32:13

29 Test29 04-SEP-2012 18:33:13

30 Test30 04-SEP-2012 18:34:13

31 Test31 04-SEP-2012 18:35:13

32 Test32 04-SEP-2012 18:36:13

33 Test33 04-SEP-2012 18:37:13

34 Test34 04-SEP-2012 18:38:13

35 Test35 04-SEP-2012 18:39:13

36 Test36 04-SEP-2012 18:40:13

0 Test0 04-SEP-2012 18:41:13

1 Test1 04-SEP-2012 18:42:13

A B C

---------- -------------------- --------------------

2 Test2 04-SEP-2012 18:43:13

3 Test3 04-SEP-2012 18:44:13

4 Test4 04-SEP-2012 18:45:13

5 Test5 04-SEP-2012 18:46:13

6 Test6 04-SEP-2012 18:47:13

7 Test7 04-SEP-2012 18:48:13

8 Test8 04-SEP-2012 18:49:13

9 Test9 04-SEP-2012 18:50:13

10 Test10 04-SEP-2012 18:51:13

11 Test11 04-SEP-2012 18:52:13

12 Test12 04-SEP-2012 18:53:13

A B C

---------- -------------------- --------------------

13 Test13 04-SEP-2012 18:54:13

14 Test14 04-SEP-2012 18:55:13

15 Test15 04-SEP-2012 18:56:13

16 Test16 04-SEP-2012 18:57:13

17 Test17 04-SEP-2012 18:58:13

18 Test18 04-SEP-2012 18:59:13

19 Test19 04-SEP-2012 19:00:13

20 Test20 04-SEP-2012 19:01:13

21 Test21 04-SEP-2012 19:02:13

22 Test22 04-SEP-2012 19:03:13

23 Test23 04-SEP-2012 19:04:13

A B C

---------- -------------------- --------------------

24 Test24 04-SEP-2012 19:05:13

25 Test25 04-SEP-2012 19:06:13

26 Test26 04-SEP-2012 19:07:13

27 Test27 04-SEP-2012 19:08:13

28 Test28 04-SEP-2012 19:09:13

29 Test29 04-SEP-2012 19:10:13

30 Test30 04-SEP-2012 19:11:13

31 Test31 04-SEP-2012 19:12:13

32 Test32 04-SEP-2012 19:13:13

33 Test33 04-SEP-2012 19:14:13

34 Test34 04-SEP-2012 19:15:13

A B C

---------- -------------------- --------------------

35 Test35 04-SEP-2012 19:16:13

36 Test36 04-SEP-2012 19:17:13

0 Test0 04-SEP-2012 19:18:13

1 Test1 04-SEP-2012 19:19:13

2 Test2 04-SEP-2012 19:20:13

3 Test3 04-SEP-2012 19:21:13

4 Test4 04-SEP-2012 19:22:13

5 Test5 04-SEP-2012 19:23:13

6 Test6 04-SEP-2012 19:24:13

7 Test7 04-SEP-2012 19:25:13

8 Test8 04-SEP-2012 19:26:13

A B C

---------- -------------------- --------------------

9 Test9 04-SEP-2012 19:27:13

10 Test10 04-SEP-2012 19:28:13

11 Test11 04-SEP-2012 19:29:13

12 Test12 04-SEP-2012 19:30:13

13 Test13 04-SEP-2012 19:31:13

14 Test14 04-SEP-2012 19:32:13

15 Test15 04-SEP-2012 19:33:13

16 Test16 04-SEP-2012 19:34:13

17 Test17 04-SEP-2012 19:35:13

18 Test18 04-SEP-2012 19:36:13

19 Test19 04-SEP-2012 19:37:13

A B C

---------- -------------------- --------------------

20 Test20 04-SEP-2012 19:38:13

21 Test21 04-SEP-2012 19:39:13

22 Test22 04-SEP-2012 19:40:13

23 Test23 04-SEP-2012 19:41:13

24 Test24 04-SEP-2012 19:42:13

25 Test25 04-SEP-2012 19:43:13

26 Test26 04-SEP-2012 19:44:13

27 Test27 04-SEP-2012 19:45:13

28 Test28 04-SEP-2012 19:46:13

29 Test29 04-SEP-2012 19:47:13

30 Test30 04-SEP-2012 19:48:13

A B C

---------- -------------------- --------------------

31 Test31 04-SEP-2012 19:49:13

32 Test32 04-SEP-2012 19:50:13

33 Test33 04-SEP-2012 19:51:13

34 Test34 04-SEP-2012 19:52:13

35 Test35 04-SEP-2012 19:53:13

36 Test36 04-SEP-2012 19:54:13

0 Test0 04-SEP-2012 19:55:13

1 Test1 04-SEP-2012 19:56:13

2 Test2 04-SEP-2012 19:57:13

3 Test3 04-SEP-2012 19:58:13

4 Test4 04-SEP-2012 19:59:13

A B C

---------- -------------------- --------------------

5 Test5 04-SEP-2012 20:00:13

6 Test6 04-SEP-2012 20:01:13

7 Test7 04-SEP-2012 20:02:13

8 Test8 04-SEP-2012 20:03:13

9 Test9 04-SEP-2012 20:04:13

10 Test10 04-SEP-2012 20:05:13

11 Test11 04-SEP-2012 20:06:13

12 Test12 04-SEP-2012 20:07:13

13 Test13 04-SEP-2012 20:08:13

14 Test14 04-SEP-2012 20:09:13

15 Test15 04-SEP-2012 20:10:13

A B C

---------- -------------------- --------------------

16 Test16 04-SEP-2012 20:11:13

17 Test17 04-SEP-2012 20:12:13

18 Test18 04-SEP-2012 20:13:13

19 Test19 04-SEP-2012 20:14:13

20 Test20 04-SEP-2012 20:15:13

21 Test21 04-SEP-2012 20:16:13

22 Test22 04-SEP-2012 20:17:13

23 Test23 04-SEP-2012 20:18:13

24 Test24 04-SEP-2012 20:19:13

25 Test25 04-SEP-2012 20:20:13

26 Test26 04-SEP-2012 20:21:13

A B C

---------- -------------------- --------------------

27 Test27 04-SEP-2012 20:22:13

28 Test28 04-SEP-2012 20:23:13

29 Test29 04-SEP-2012 20:24:13

30 Test30 04-SEP-2012 20:25:13

31 Test31 04-SEP-2012 20:26:13

32 Test32 04-SEP-2012 20:27:13

33 Test33 04-SEP-2012 20:28:13

34 Test34 04-SEP-2012 20:29:13

35 Test35 04-SEP-2012 20:30:13

36 Test36 04-SEP-2012 20:31:13

0 Test0 04-SEP-2012 20:32:13

A B C

---------- -------------------- --------------------

1 Test1 04-SEP-2012 20:33:13

2 Test2 04-SEP-2012 20:34:13

3 Test3 04-SEP-2012 20:35:13

4 Test4 04-SEP-2012 20:36:13

5 Test5 04-SEP-2012 20:37:13

6 Test6 04-SEP-2012 20:38:13

7 Test7 04-SEP-2012 20:39:13

8 Test8 04-SEP-2012 20:40:13

9 Test9 04-SEP-2012 20:41:13

10 Test10 04-SEP-2012 20:42:13

11 Test11 04-SEP-2012 20:43:13

A B C

---------- -------------------- --------------------

12 Test12 04-SEP-2012 20:44:13

13 Test13 04-SEP-2012 20:45:13

14 Test14 04-SEP-2012 20:46:13

15 Test15 04-SEP-2012 20:47:13

16 Test16 04-SEP-2012 20:48:13

17 Test17 04-SEP-2012 20:49:13

18 Test18 04-SEP-2012 20:50:13

19 Test19 04-SEP-2012 20:51:13

20 Test20 04-SEP-2012 20:52:13

21 Test21 04-SEP-2012 20:53:13

22 Test22 04-SEP-2012 20:54:13

A B C

---------- -------------------- --------------------

23 Test23 04-SEP-2012 20:55:13

24 Test24 04-SEP-2012 20:56:13

25 Test25 04-SEP-2012 20:57:13

26 Test26 04-SEP-2012 20:58:13

27 Test27 04-SEP-2012 20:59:13

28 Test28 04-SEP-2012 21:00:13

29 Test29 04-SEP-2012 21:01:13

30 Test30 04-SEP-2012 21:02:13

31 Test31 04-SEP-2012 21:03:13

32 Test32 04-SEP-2012 21:04:13

33 Test33 04-SEP-2012 21:05:13

A B C

---------- -------------------- --------------------

34 Test34 04-SEP-2012 21:06:13

35 Test35 04-SEP-2012 21:07:13

36 Test36 04-SEP-2012 21:08:13

0 Test0 04-SEP-2012 21:09:13

1 Test1 04-SEP-2012 21:10:13

2 Test2 04-SEP-2012 21:11:13

3 Test3 04-SEP-2012 21:12:13

4 Test4 04-SEP-2012 21:13:13

5 Test5 04-SEP-2012 21:14:13

6 Test6 04-SEP-2012 21:15:13

7 Test7 04-SEP-2012 21:16:13

A B C

---------- -------------------- --------------------

8 Test8 04-SEP-2012 21:17:13

9 Test9 04-SEP-2012 21:18:13

10 Test10 04-SEP-2012 21:19:13

11 Test11 04-SEP-2012 21:20:13

12 Test12 04-SEP-2012 21:21:13

13 Test13 04-SEP-2012 21:22:13

14 Test14 04-SEP-2012 21:23:13

15 Test15 04-SEP-2012 21:24:13

16 Test16 04-SEP-2012 21:25:13

17 Test17 04-SEP-2012 21:26:13

18 Test18 04-SEP-2012 21:27:13

A B C

---------- -------------------- --------------------

19 Test19 04-SEP-2012 21:28:13

20 Test20 04-SEP-2012 21:29:13

21 Test21 04-SEP-2012 21:30:13

22 Test22 04-SEP-2012 21:31:13

23 Test23 04-SEP-2012 21:32:13

24 Test24 04-SEP-2012 21:33:13

25 Test25 04-SEP-2012 21:34:13

26 Test26 04-SEP-2012 21:35:13

27 Test27 04-SEP-2012 21:36:13

28 Test28 04-SEP-2012 21:37:13

29 Test29 04-SEP-2012 21:38:13

A B C

---------- -------------------- --------------------

30 Test30 04-SEP-2012 21:39:13

31 Test31 04-SEP-2012 21:40:13

32 Test32 04-SEP-2012 21:41:13

33 Test33 04-SEP-2012 21:42:13

34 Test34 04-SEP-2012 21:43:13

35 Test35 04-SEP-2012 21:44:13

36 Test36 04-SEP-2012 21:45:13

0 Test0 04-SEP-2012 21:46:13

1 Test1 04-SEP-2012 21:47:13

2 Test2 04-SEP-2012 21:48:13

3 Test3 04-SEP-2012 21:49:13

A B C

---------- -------------------- --------------------

4 Test4 04-SEP-2012 21:50:13

5 Test5 04-SEP-2012 21:51:13

6 Test6 04-SEP-2012 21:52:13

7 Test7 04-SEP-2012 21:53:13

8 Test8 04-SEP-2012 21:54:13

9 Test9 04-SEP-2012 21:55:13

10 Test10 04-SEP-2012 21:56:13

11 Test11 04-SEP-2012 21:57:13

12 Test12 04-SEP-2012 21:58:13

13 Test13 04-SEP-2012 21:59:13

14 Test14 04-SEP-2012 22:00:13

A B C

---------- -------------------- --------------------

15 Test15 04-SEP-2012 22:01:13

16 Test16 04-SEP-2012 22:02:13

17 Test17 04-SEP-2012 22:03:13

18 Test18 04-SEP-2012 22:04:13

19 Test19 04-SEP-2012 22:05:13

20 Test20 04-SEP-2012 22:06:13

21 Test21 04-SEP-2012 22:07:13

22 Test22 04-SEP-2012 22:08:13

23 Test23 04-SEP-2012 22:09:13

24 Test24 04-SEP-2012 22:10:13

25 Test25 04-SEP-2012 22:11:13

A B C

---------- -------------------- --------------------

26 Test26 04-SEP-2012 22:12:13

27 Test27 04-SEP-2012 22:13:13

28 Test28 04-SEP-2012 22:14:13

29 Test29 04-SEP-2012 22:15:13

30 Test30 04-SEP-2012 22:16:13

31 Test31 04-SEP-2012 22:17:13

32 Test32 04-SEP-2012 22:18:13

33 Test33 04-SEP-2012 22:19:13

34 Test34 04-SEP-2012 22:20:13

35 Test35 04-SEP-2012 22:21:13

36 Test36 04-SEP-2012 22:22:13

A B C

---------- -------------------- --------------------

0 Test0 04-SEP-2012 22:23:13

1 Test1 04-SEP-2012 22:24:13

2 Test2 04-SEP-2012 22:25:13

3 Test3 04-SEP-2012 22:26:13

4 Test4 04-SEP-2012 22:27:13

5 Test5 04-SEP-2012 22:28:13

6 Test6 04-SEP-2012 22:29:13

7 Test7 04-SEP-2012 22:30:13

8 Test8 04-SEP-2012 22:31:13

9 Test9 04-SEP-2012 22:32:13

10 Test10 04-SEP-2012 22:33:13

A B C

---------- -------------------- --------------------

11 Test11 04-SEP-2012 22:34:13

12 Test12 04-SEP-2012 22:35:13

13 Test13 04-SEP-2012 22:36:13

14 Test14 04-SEP-2012 22:37:13

15 Test15 04-SEP-2012 22:38:13

16 Test16 04-SEP-2012 22:39:13

17 Test17 04-SEP-2012 22:40:13

18 Test18 04-SEP-2012 22:41:13

19 Test19 04-SEP-2012 22:42:13

20 Test20 04-SEP-2012 22:43:13

21 Test21 04-SEP-2012 22:44:13

A B C

---------- -------------------- --------------------

22 Test22 04-SEP-2012 22:45:13

23 Test23 04-SEP-2012 22:46:13

24 Test24 04-SEP-2012 22:47:13

25 Test25 04-SEP-2012 22:48:13

26 Test26 04-SEP-2012 22:49:13

27 Test27 04-SEP-2012 22:50:13

28 Test28 04-SEP-2012 22:51:13

29 Test29 04-SEP-2012 22:52:13

30 Test30 04-SEP-2012 22:53:13

31 Test31 04-SEP-2012 22:54:13

32 Test32 04-SEP-2012 22:55:13

A B C

---------- -------------------- --------------------

33 Test33 04-SEP-2012 22:56:13

34 Test34 04-SEP-2012 22:57:13

35 Test35 04-SEP-2012 22:58:13

36 Test36 04-SEP-2012 22:59:13

0 Test0 04-SEP-2012 23:00:13

1 Test1 04-SEP-2012 23:01:13

2 Test2 04-SEP-2012 23:02:13

3 Test3 04-SEP-2012 23:03:13

4 Test4 04-SEP-2012 23:04:13

5 Test5 04-SEP-2012 23:05:13

6 Test6 04-SEP-2012 23:06:13

A B C

---------- -------------------- --------------------

7 Test7 04-SEP-2012 23:07:13

8 Test8 04-SEP-2012 23:08:13

9 Test9 04-SEP-2012 23:09:13

10 Test10 04-SEP-2012 23:10:13

11 Test11 04-SEP-2012 23:11:13

12 Test12 04-SEP-2012 23:12:13

13 Test13 04-SEP-2012 23:13:13

14 Test14 04-SEP-2012 23:14:13

15 Test15 04-SEP-2012 23:15:13

16 Test16 04-SEP-2012 23:16:13

17 Test17 04-SEP-2012 23:17:13

A B C

---------- -------------------- --------------------

18 Test18 04-SEP-2012 23:18:13

19 Test19 04-SEP-2012 23:19:13

20 Test20 04-SEP-2012 23:20:13

21 Test21 04-SEP-2012 23:21:13

22 Test22 04-SEP-2012 23:22:13

23 Test23 04-SEP-2012 23:23:13

24 Test24 04-SEP-2012 23:24:13

25 Test25 04-SEP-2012 23:25:13

26 Test26 04-SEP-2012 23:26:13

27 Test27 04-SEP-2012 23:27:13

28 Test28 04-SEP-2012 23:28:13

A B C

---------- -------------------- --------------------

29 Test29 04-SEP-2012 23:29:13

30 Test30 04-SEP-2012 23:30:13

31 Test31 04-SEP-2012 23:31:13

32 Test32 04-SEP-2012 23:32:13

33 Test33 04-SEP-2012 23:33:13

34 Test34 04-SEP-2012 23:34:13

963 rows selected.

SQL>

Far more than 37 duplicates exist in that table; we'll rollback the transaction and try again:

SQL> rollback;

Rollback complete.

SQL>

SQL> delete from mydupes

2 where rowid not in (select max(rowid)

3 from mydupes

4 group by a, b

5 having count(*) > 1);

963 rows deleted.

SQL>

SQL> select a, b, c

2 from mydupes;

A B C

---------- -------------------- --------------------

35 Test35 04-SEP-2012 23:35:13

36 Test36 04-SEP-2012 23:36:13

0 Test0 04-SEP-2012 23:37:13

1 Test1 04-SEP-2012 23:38:13

2 Test2 04-SEP-2012 23:39:13

3 Test3 04-SEP-2012 23:40:13

4 Test4 04-SEP-2012 23:41:13

5 Test5 04-SEP-2012 23:42:13

6 Test6 04-SEP-2012 23:43:13

7 Test7 04-SEP-2012 23:44:13

8 Test8 04-SEP-2012 23:45:13

A B C

---------- -------------------- --------------------

9 Test9 04-SEP-2012 23:46:13

10 Test10 04-SEP-2012 23:47:13

11 Test11 04-SEP-2012 23:48:13

12 Test12 04-SEP-2012 23:49:13

13 Test13 04-SEP-2012 23:50:13

14 Test14 04-SEP-2012 23:51:13

15 Test15 04-SEP-2012 23:52:13

16 Test16 04-SEP-2012 23:53:13

17 Test17 04-SEP-2012 23:54:13

18 Test18 04-SEP-2012 23:55:13

19 Test19 04-SEP-2012 23:56:13

A B C

---------- -------------------- --------------------

20 Test20 04-SEP-2012 23:57:13

21 Test21 04-SEP-2012 23:58:13

22 Test22 04-SEP-2012 23:59:13

23 Test23 05-SEP-2012 00:00:13

24 Test24 05-SEP-2012 00:01:13

25 Test25 05-SEP-2012 00:02:13

26 Test26 05-SEP-2012 00:03:13

27 Test27 05-SEP-2012 00:04:13

28 Test28 05-SEP-2012 00:05:13

29 Test29 05-SEP-2012 00:06:13

30 Test30 05-SEP-2012 00:07:13

A B C

---------- -------------------- --------------------

31 Test31 05-SEP-2012 00:08:13

32 Test32 05-SEP-2012 00:09:13

33 Test33 05-SEP-2012 00:10:13

34 Test34 05-SEP-2012 00:11:13

37 rows selected.

SQL>

How one deletes duplicate rows is as much a factor of how many duplicates exist as well as just knowing there are duplicate rows in the table. It also depends on which of the duplicates should be saved:

SQL> rollback;

Rollback complete.

SQL>

SQL> delete from mydupes

2 where rowid not in (select min(rowid)

3 from mydupes

4 group by a, b

5 having count(*) > 1);

963 rows deleted.

SQL>

SQL> select a, b, c

2 from mydupes;

A B C

---------- -------------------- --------------------

35 Test35 05-SEP-2012 00:12:13

36 Test36 05-SEP-2012 00:13:13

0 Test0 05-SEP-2012 00:14:13

1 Test1 05-SEP-2012 00:15:13

2 Test2 05-SEP-2012 00:16:13

3 Test3 05-SEP-2012 00:17:13

4 Test4 05-SEP-2012 00:18:13

5 Test5 05-SEP-2012 00:19:13

6 Test6 05-SEP-2012 00:20:13

7 Test7 05-SEP-2012 00:21:13

8 Test8 05-SEP-2012 00:22:13

A B C

---------- -------------------- --------------------

9 Test9 05-SEP-2012 00:23:13

10 Test10 05-SEP-2012 00:24:13

11 Test11 05-SEP-2012 00:25:13

12 Test12 05-SEP-2012 00:26:13

13 Test13 05-SEP-2012 00:27:13

14 Test14 05-SEP-2012 00:28:13

15 Test15 05-SEP-2012 00:29:13

16 Test16 05-SEP-2012 00:30:13

17 Test17 05-SEP-2012 00:31:13

18 Test18 05-SEP-2012 00:32:13

19 Test19 05-SEP-2012 00:33:13

A B C

---------- -------------------- --------------------

20 Test20 05-SEP-2012 00:34:13

21 Test21 05-SEP-2012 00:35:13

22 Test22 05-SEP-2012 00:36:13

23 Test23 05-SEP-2012 00:37:13

24 Test24 05-SEP-2012 00:38:13

25 Test25 05-SEP-2012 00:39:13

26 Test26 05-SEP-2012 00:40:13

27 Test27 05-SEP-2012 00:41:13

28 Test28 05-SEP-2012 00:42:13

29 Test29 05-SEP-2012 00:43:13

30 Test30 05-SEP-2012 00:44:13

A B C

---------- -------------------- --------------------

31 Test31 05-SEP-2012 00:45:13

32 Test32 05-SEP-2012 00:46:13

33 Test33 05-SEP-2012 00:47:13

34 Test34 05-SEP-2012 00:48:13

37 rows selected.

SQL>

In the first case the earliest dated records were preserved, and in the latter case the latest dated records were preserved. Knowing WHICH of the duplicates to save is also as important..

David Fitzjarrell

jgar the jorrible

unread,

Sep 5, 2012, 6:08:50 PM9/5/12

to ORACLE_DBA_EXPERTS

Also check the faq: http://www.orafaq.com/faq/how_does_one_eliminate_duplicates_rows_from_a_table

jg
--
@home.com is bogus.
http://www.businessinsider.com/oracle-confirms-that-it-wont-abandon-hps-itanium-customers-2012-9

Reply all

Reply to author

Forward

0 new messages