Hi,
I have some record as below
Date Teacher rownum
01-01-2019 William 1
02-01-2019 Brandon 1
01-01-2019 William 2
02-01-2019 Edith 1
02-01-2019 John 1
02-01-2019 John 2
I want to show record that only have more than 1 record so the result will be
Date Teacher rownum
01-01-2019 William 1
01-01-2019 William 2
02-01-2019 John 1
02-01-2019 John 2
So what is the command...
Thx,
Joe