| question on return function [message #191610] |
Thu, 07 September 2006 05:24  |
lohi
Messages: 2
Registered: July 2006
|
Junior Member |
|
|
hi,
plz anybody tell me the ans for this question
difference between -
select * from tablename; and select * from tablename; return
|
|
|
|
|
|
| Re: question on return function [message #191633 is a reply to message #191613] |
Thu, 07 September 2006 06:42  |
lohi
Messages: 2
Registered: July 2006
|
Junior Member |
|
|
when given select * from tablename; - displayed all the rows.
now if we give select * from tablename; return - displayed all rows.
but if we give any sql stmt after the qury which used return it is not functioning.
select * from employees; return
select * from employees
if given like this displaying the table only once.
if given select * from employees;
select * from employees; return
select * from orders;
only emp table displayed.
so,plz can u explain clearly.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
