Posted by: Fridolin Schwarz
I would appreciate if it would be possible to issue nested selects like
SELECT * FROM (SELECT * FROM ).
This feature is very comfortable in Oracle or SqlServer.
Also I would be happy if a TOP N-Restriction, or Oracle-Like with ROWNUM,
could be introduced. This would be advantageous if you only need the topmost
N records of a result set.
Smart as well is the usage of temporary objects. I think SqlServer found a
good solution for this topic, that could be copied. Temporary tables in
Oracle, in my opinion, are not as flexible as their M$-counterparts.