SACHIN

• Aug 12th, 2005

 

SINGLE ROW SUBQUERY RETURNS A VALUE WHICH IS USED BY WHERE CLAUSE , WHEREAS SCALAR SUBQUERY IS A SELECT STATEMENT USED IN COLUMN LIST CAN BE THOUGHT OF AS AN INLINE FUNCTION IN SELECT COLUMN LIST

B.Vijay Karthik

• Sep 1st, 2005

 

Single row subqueries returns only one row of results.A single row sub query uses a single row operator; the common operator is the equality operator(=). 
A Scalar subquery returns exactly one column value from one row.Scalar subqueris can be ysed in most places where you would use a column nae or expression, such as inside a sigle row function as an argument, in insert, order by clause, where clause, case expressions but not in group by or having clause.