SQL: Select FROM( SELECT)

forum.wishlist (1998-2005) & forum.gupta.wishlist (2005-2010)
Fridolin Schwarz

SQL: Select FROM( SELECT)

Post by Fridolin Schwarz » 14 Jul 2004, 23:49

 Posted by:  Fridolin Schwarz 

Hi all,

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.

greetings
fritz

Return to “gupta.wishlist”

Who is online

Users browsing this forum: [Ccbot] and 0 guests