[HACKERS] How to use nested select statements

[Sanjay Arora]

Hello everybody

First of all I wold like to thank you in advance because I am sure
that I would get my answer immediately.

Well I want to use nested select statements ,is it possible.
Is there any counterpart for 'Sysdate from dual' as in Oracle

with Regards

Sanjay Arora