If select distinct removes duplicates, How do you do you do just the opposite? For example the table contains 11111 12345 12345 12345 22222 33333 99999 99999
I only want to retrieve 12345, 99999 all others should not show up in results. Can this be done? Can this be done?
There aren't may rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.