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 ...

what is the use of friend function? : Sql dba

1061

---

How do I write a sql query in pgadmin 4?

1046

---

Can you load data into multiple tables at once? : aql loader

1118

---

What is asqueryable?

1036

---

explain the advantages and disadvantages of stored procedure? : Sql dba

1065

---

What is a table partition?

1206

---

How many joins can you have in sql?

988

---

what are the differences between require and include, include_once and require_once? : Sql dba

1069

---

How do I remove sql developer from windows 10?

1184

---

What types of commands can be executed in sql*plus?

1164

---

What is data abstraction in sql?

1066

---

Is progress software supports to ( pl/sql )?

1098

---

Is oracel sql developer written in java?

1169

---

What is sql profiler in oracle?

1160

---

Is it possible for a table to have more than one foreign key?

1082

---