select max(rownum) from table1 where rowid is not null

how u can find the n row from a table?

Question Posted / rashmi

Answer Posted / rashmi

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of primary key?

1029

Does sql full backup truncate logs?

1017

Why plvtab is considered as the easiest way to access the pl/sql table?

1216

How does cross join work in sql?

1018

what is a view? : Sql dba

1094

how to show all tables with 'mysql'? : Sql dba

1118

Which are the different case manipulation functions in sql?

1023

How many commands are in sql?

1072

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016

What is scalar function in sql?

1040

How to write html code in pl sql?

1119

What is the unique index?

1054

How do you define a foreign key?

1004

What is a sql instance vs database?

1117

Can we insert data into view?

903