Never returns anything.Originally posted by Mnemonical
select * from table where rownum = ( select count(*) from table)
Only meaningful conditions for rownum are
rownum<
rownum<=
rownum=1
The base question is still unanswered: What does LAST RECORD mean?




Reply With Quote