syntax and formatting

[db2HelpNeeded]

Hello,
looking for help in trying to run an inline view and then doing a select * off of that inline view. Something like this... but this gives me an error

SELECT * FROM (SELECT D.OID, A.DATEVALUEX AS SortValue
FROM DOCUMENTS D LEFT OUTER JOIN ATTRIBUTES A ON D.OID=A.DocumentOID AND A.AttributeDefOID=955
WHERE STATUSX=0 ORDER BY SortValue DESC)
fetch first 100 rows only

 

[blom0344]

SELECT TEMP.KEY,TEMP.SortValue FROM (SELECT D.OID AS KEY, A.DATEVALUEX AS SortValue 
FROM DOCUMENTS D LEFT OUTER JOIN ATTRIBUTES A  ON D.OID=A.DocumentOID AND A.AttributeDefOID=955 
WHERE STATUSX=0 ORDER BY SortValue DESC) TEMP
fetch first 100 rows only

Why the inline view?


Ties Blom

 

[db2HelpNeeded]

wanted to make sure I get the sort done first and then take the first 100.

 

[sathyarams]

Doesn't make a difference ... You don't need the inline view

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[blom0344]

Well that was my point as well..

Ties Blom