Ed Dressel wrote:

>> select 1 from DetailInfo d where ...
>
> what does the '1' do in this SQL?
>

You have to have something in the field list, but you are not
interested in anything in particular. So, "1" is convenient - but
you could just as well use "*" (select * from ...).

--
Aage J.