Answer Posted / ananth

this is for 2nd highest sal in sql server database

select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))

How to call a sub procedure?

796

---

What do you understand by a database object?

778

---

Difference between inner join vs where ?

772

---

WHAT IS ecc 6.0

1895

---

What is bulk copy or bcp in oracle?

809

---

---

How to find out what oracle odbc drivers are installed?

792

---

What is a nested table?

798

---

defination of bitmap index

1791

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1672

---

How to download oracle database 10g xe?

766

---

What is a named program unit?

771

---

What are the varoius components of physical database structure of oracle database?

733

---

Explain oracle instance.

876

---

How to change system global area (sga) in oracle?

762

---

How to get execution statistics reports on query statements?

791

---