Interested to Buy Any Domain ? << Click Here >> for more details...
how u can find the n row from a table?
- 19 Answers
- 30123 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / manish singhania
select * from emp where rownum<=n
minus
select * from emp where rownum<n
n=1,2,......so many
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What do you understand by pl/sql packages?
What is the difference between python and sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the purpose of a sql?
How do you write a subquery?
Why do we use procedures in pl sql?
Is it possible to update views?
Why do we need pl sql?
What is data modelling in sql?
how many values can the set function of mysql take? : Sql dba
Can primary key be changed?
how can we find the number of rows in a table using mysql? : Sql dba
What are database links used for?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Why is sql better than hql?
