I have subquery into a principal query, and i need the subquery return me only the last row of all results, but i can`t use "order by <field> desc " in the subquery because this return me an error, nither "fetch first 1 rows only" because this return a error too. Any sugestion?


this es the SQL...

Code:
SELECT
  C.NOMBRE,V.COBJCOD,CS.DESC,V.CSUBCOD,
  N.NOMBRE,CS.NIVEL,V.SUBLIBRO,
...