Answer Posted / m.raghu

answer for 101th record

select * from emp where empno in( select decode
(rownum,&n,empno) from emp);

for 4th highest sal

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk=&n;

for 5th highest sal give n value=5
for 1-10

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk<=&n;

what are the authentication modes in sql server? : Sql dba

1000

---

When are we going to use truncate and delete?

927

---

Write an sql query to select all records from the table?

970

---

What is data types in sql?

951

---

Is it important to partition hard disk?

967

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1537

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1042

---

Can we use distinct and group by together?

994

---

How can we avoid duplicating records in a query?

925

---

Can you have more than one key in a database?

893

---

What is difference between rank () row_number () and dense_rank () in sql?

1052

---

What is sql injection vulnerability?

872

---

Why do you partition data?

967

---

Can we call procedure in select statement?

976

---

Explain alias in sql?

997

---