Answer Posted / john bershan

select sgp from (select sgp,dense_rank() over (order by
sgp desc) as rownumber from t_policy_general)
where rownumber = '100';

What is on delete restrict?

1068

---

What is lexical units in pl sql?

1204

---

What is auto increment?

1044

---

How do I enable sql encryption?

1069

---

What is a variable in sql?

1049

---

What is using in sql?

1139

---

What is %s in sql?

1075

---

Which is faster truncate or drop?

1097

---

What is trigger price?

1046

---

What is union and union all keyword in sql?

1109

---

How does sql*loader handles newline characters in a record? : aql loader

1089

---

Can we use loop in sql?

1010

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1244

---

What are predefined functions in sql?

1105

---

What is the difference between left join and right join?

986

---