Answer Posted / karthik ramasamy

Select max(salary) from salarymaster where salary <(select
max(salary) from salarymaster)

OR

SELECT MAX(SALARY) FROM SALARYMASTER WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM SALARYMASTER)

OR

Select max(salary) from salarymaster where salary<(Select
max(salary) from salarymaster)

When you have to use a default "rollback to" savepoint of plvlog?

1249

---

Is left join same as join?

1035

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2549

---

What is a column in a table?

1185

---

What is the main difference between sql and pl/sql?

1146

---

List the different type of joins?

1113

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2546

---

What is time based sql injection?

1032

---

What is sql key?

1043

---

Enlist the data types that can be used in pl/sql?

1106

---

Can we create foreign key without primary key?

1036

---

What is sqlca in db2?

1032

---

what is a stored procedure? : Sql dba

1189

---

How can we debug in PL/SQL?

1181

---

How many functions are there in sql?

1092

---