Broadcom Mainframe Software Community

 View Only
Back to discussions
Expand all | Collapse all

Datacom SQL: Select first n rows in a result set (i.e. select top(n) *)

  • 1.  Datacom SQL: Select first n rows in a result set (i.e. select top(n) *)

    Posted Aug 05, 2020 01:07 PM
    Hello,
    I get an error when converting a SQL query (written for Microsoft SQL server) to Datacom SQL that has select top(1) in subqueries:

    SQL server query:
    select * from (select top(10)* from TableX) as tempTable

    (My attempt) Datacom queries:
    select * from (select * from TableX fetch first 10 rows only) as tempTable

    The Datacom Sql query above fails, can you please correct it?

    More general, how to convert select top(n) to Datacom SQL?

    I don't know why fetch first 10 rows only work in queries without subqueries but doesn't work with nested queries?
    Thank you.