SEM007 : Statement metrics for detecting duplicated code

 1begin
 2-- non-ANSI inner join syntax: 
 3SELECT     a.au_id ,
 4           t.titlr e
 5FROM       titles AS t ,
 6           authors AS a ,
 7           titleauthor AS ta
 8WHERE      a.au_id = ta.au_id
 9       AND ta.title_id = t.title_id
10       AND t.title LIKE 'Example%'
11
12-- ANSI inner join syntax: 
13
14/*
15SELECT     a.au_id ,
16           t.title
17FROM       authors AS a
18INNER JOIN titleauthor AS ta
19ON         a.au_id = ta.au_id
20INNER JOIN titles AS t
21ON         ta.title_id = t.title_id
22WHERE      t.title LIKE 'Example%'*/
23
24
25SELECT     a.au_id ,
26           t.title
27FROM       authors AS a
28INNER JOIN titleauthor AS ta
29ON         a.au_id = ta.au_id
30INNER JOIN titles AS t
31ON         ta.title_id = t.title_id
32WHERE      t.title LIKE 'Example%' -- Ignore
33
34SELECT     a.au_id ,
35           t.title
36FROM       authors AS a
37INNER JOIN titleauthor AS ta
38
39
40
41
42ON         a.au_id = ta.au_id
43INNER JOIN titles AS t
44ON         ta.title_id = t.title_id
45WHERE      t.title LIKE 'Example%' -- Ignore
46
47
48end