Answer Posted / tulasi ravi kumar
hi this tulasi .....+91-9951123501
in SQL Server 2000 we write as...
declare CurTemp scroll cursor for
select top 2 * from <table_name>
open CurTemp
fetch last from CurTemp
close CurTemp
deallocate CurTemp;
in ORACLE , we can write as..
select * fom <table_name>
where rowid=(select rowid from <table_name>where rownum<=2
minus
select rowid from <table_name>
where rownum<2;
so try it ...
Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
What is compute?
How to avoid using cursors?
What is meant by truncate in sql?
what is 'mysqld'? : Sql dba
How is sql used in oracle?
how can you see all indexes defined for a table? : Sql dba
What plvcmt and plvrb does in pl/sql?
Can we perform dml on view?
Explain the purpose of %type and %rowtype data types?
What does (*) mean in sql?
What do we need to check in database testing?
Can you have more than one trigger on a table?
What is a primary key? Explain
What is the importance of sqlcode and sqlerrm?
Define commit?