Answer Posted / meher

Let the table name is EMP

To find 101st row the query is as below:

select * from EMP where rownum <= 101
minus
select * from EMP where rownum <= 100;


for Nth salary the query is as below:

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

What is cursor status?

1190

---

Can variables be used in sql statements?

1036

---

Can we edit a view in sql?

988

---

How to create an array in pl/sql?

1073

---

What is a system versioned table?

992

---

What is lookup table in sql?

1053

---

What is group by in sql?

1086

---

What are actual parameters and formal parameters?

1107

---

How do you create an update query?

965

---

Can we enter data in a table in design view?

969

---

How to pipe multiline string to isql?

1007

---

What is the difference between the conventional and direct path loader? : aql loader

1157

---

What is data modelling in sql?

1024

---

what is the difference between a local and a global temporary table? : Sql dba

1073

---

What is the file extension for sql database?

1006

---