Interested to Buy Any Domain ? << Click Here >> for more details...
how u can find the n row from a table?
- 19 Answers
- 29564 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
Explain what is a database?
What if we write return in procedure?
Is sql a microsoft product?
What are the different types of database management systems?
What is sqlservr exe?
What is cursor in pl sql with examples?
How do you optimize a query?
What is record type in pl sql?
what is a trigger? : Sql dba
What is the clause we need to add in function body to return variable?
Which sql statement is used to delete data from a database?
How can you fetch first 5 characters of the string?
What is the difference between local and global temporary table?
explain the difference between bool, tinyint and bit. : Sql dba
What are the advantages of sql?
