how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What are the different set operators available in sql?

0 Answers  

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

What are sql objects?

0 Answers  

---

---

How much does sql cost?

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

Which operator is used in query for pattern matching?

0 Answers  

---