How to get / select the nth row from the table?

Question Posted / vikas agarwal

1 Answers
30 Views
I also Faced
E-Mail Answers

How to get / select the nth row from the table?..

Answer / Versha Rawat

"To select the nth row from a table in Oracle D2K, you can use the ROWNUM pseudo-column along with a WHERE clause. For example: SELECT * FROM my_table WHERE ROWNUM = n."

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle D2K Interview Questions

What are referenced objects? Explain the importance of referencing.

1 Answers

What is call form stack?

1 Answers

Difference between lexical and bind varible.

1 Answers

What is bind variables in oracle reports?

1 Answers

How to avoid duplicate entries in the forms?

1 Answers

how can you pass values to-and-fro from foreign function?

1 Answers

How to convert the oracle reports to excel sheet from oracle?

1 Answers

What are object group?

1 Answers

Explain the different types of queries created in reports?

1 Answers

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

1 Answers

How is mapping of name of dll and function done?

1 Answers

What is the format trigger?

1 Answers

For more Oracle D2K Interview Questions Click Here