Home Forums SQL Server 2008 Working with Oracle Error when selecting top N records from oracle RE: Error when selecting top N records from oracle
ivan.peter
SSC Enthusiast
Points: 181
More actions
July 28, 2014 at 12:47 am
#1732702
Have you tried this?
Select top 100 * from (
select * from table1
left outer join table2 on table1.id = table2.id
left outer join table3 on table1.id = table3.id
)
Also be notified that rownum < 100 returns 99 rows only. Use rownum <= 100.