how u can find the n row from a table?
- 19 Answers
- 24181 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / rama krishna
If you want nth record from table employee then..
select * from employee where rownum <= n
minus
select * from employee where rownum < n
the above query will suffice.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is java sql drivermanager?
What is form and report?
How is a process of pl/sql compiled?
Differentiate pl/sql and sql?
What is cold data?
what is self join and what is the requirement of self join? : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are stored procedures used for?
Why we use sql profiler?
What is pls integer?
What are different joins used in sql?
Does group by remove duplicates?
What is sqlerrm?
how to do backup entire database? : Transact sql
What is the difference between python and sql?
