Need support to convert SQL Server query to Oracle

Question

The TableC and TableB have multiple records, I want select multiple records from TableB and one record from TableC which is working in SQL Server. But actual requirement in Oracle database where it's not working. Please help to convert below SQL Server query to Oracle.

Select 
     Data-A,
     Data-B,
    (Select Top 1 DATA-C from
     TableC Where TableC.SourcePtr=Tabbleb.Rkey order by Step Desc) as Data-C
From TableA,
     TableB
Where TableA.Source_PTR =TableB.Rkey

Does this answer your question? How to select top 1 and ordered by date in Oracle SQL? — astentx
– astentx, Commented Aug 23, 2021 at 7:55
Does this answer your question? How do I limit the number of rows returned by an Oracle query after ordering? — Serg
– Serg, Commented Aug 23, 2021 at 8:00

TimLer · Accepted Answer · 2021-08-23 08:03:45Z

2

You can use ROWNUM:

Select 
     Data-A,
     Data-B,
     (Select * from (
        (
            Select data-C from TableC 
            Where TableC.SourcePtr=Tabbleb.Rkey order by Step Desc
        )
      where rownum = 1 ) as Data-C
From TableA,
     TableB
Where TableA.Source_PTR =TableB.Rkey

or you can use FETCH NEXT N ROWS ONLY:

Select 
     Data-A,
     Data-B,
     (Select DATA-C from TableC 
      Where TableC.SourcePtr=Tabbleb.Rkey order by Step Desc
      FETCH NEXT 1 ROWS ONLY) as Data-C
From TableA,
     TableB
Where TableA.Source_PTR =TableB.Rkey

edited Aug 23, 2021 at 8:03

answered Aug 23, 2021 at 7:55

TimLer

1,3604 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Karthik Over a year ago

Rezu :) Thanks a lot

Collectives™ on Stack Overflow

Need support to convert SQL Server query to Oracle

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related