Answer Posted / dharmendra

select max(salary) from table
where salary < (select max(salary) from table);

What are the ways on commenting in a pl/sql code?

515

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

560

---

What is union and union all keyword in sql?

568

---

What is recursive join in sql?

554

---

What is a join query?

556

---

---

What's the difference between inner join and left join?

518

---

Are subqueries faster than joins?

579

---

what is timestamp in mysql? : Sql dba

570

---

what is the difference between union and union all? : Sql dba

548

---

What is a unique key?

590

---

What is the left table in sql?

521

---

How many scalar data types are supported in pl/sql?

530

---

Which software is used for pl sql programming?

526

---

what are the t string functions available in tsql? : Transact sql

545

---

Explain the difference between triggers and constraints?

523

---