Answer Posted / kotravel. b

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);



THIS will surly give 2^nd max sal ok this correct ans ok....

What is pragma in sql?

620

---

Does oracle roll back the transaction on an error?

531

---

What are the types of triggers in sql?

496

---

What are the types of operators available in sql?

552

---

what is a stored procedure? : Sql dba

548

---

---

What is the difference between joins?

534

---

Which is faster count (*) or count 1?

538

---

What is the command used to fetch first 5 characters of the string?

880

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

805

---

What is pl sql variable?

502

---

where are cookies actually stored on the hard disk? : Sql dba

578

---

Define SQL and state the differences between SQL and other conventional programming Languages?

679

---

What is left join in sql?

581

---

What is sqlservr exe?

478

---

What is implicit cursor in pl sql?

537

---