Answer Posted / sachin

select max(sal) from employees
where salary < (select max(sal) from employees);

What are the most important ddl statements in sql?

1117

---

What are pl sql data types?

1017

---

explain the difference between delete , truncate and drop commands? : Sql dba

1097

---

how to enter binary numbers in sql statements? : Sql dba

978

---

Explain the methods used to protect source code of pl/sql.

1023

---

How to get each name only once from an employee table?

1116

---

How is debugging done?

984

---

What does the hierarchical profiler does?

1062

---

What is constant in pl sql?

1026

---

What is sql architecture?

1056

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

how would you enter characters as hex numbers? : Sql dba

986

---

How to avoid duplicate records in a query?

1009

---

How do you delete duplicates in sql query using rowid?

949

---

What are inner and outer joins examples of both?

965

---