Re: the difference between single row query and multi row query

denver33 wrote:
>
>
> I don't know the difference between single row query and multi row query
 in
> sql query..
>
> can you tell me the difference the two item?
>
>
>
 

     Are you asking questions about "single row sub query , and multi row

sub query"?  If that's the case , then....... Single row sub query return 
only one row from the inner SELECT statement..Its uses single-row 
comparison operator such as the following ....  =,>,>=,<,<= and not <>...
  

    The multi row sub query return more THAN one rows for that query...Its coparison operator are.. IN, ANY, and, ALL.

    Well, hope that clear things up a little for you...

--
Posted via CNET Help.com
http://www.help.com/