Answer Posted / souri sengupta

select max(salary) from employee where salary not in (select max(salary) from employee);


This worked :)

What is coalesce function?

575

---

How to create a new table in oracle?

591

---

What is bulk copy or bcp in oracle?

606

---

How to create a new oracle data file?

556

---

How to convert character types to numeric types?

578

---

---

Difference between cartesian join and cross join?

543

---

What is the difference between pre-select and pre-query?

621

---

What is the purpose of save points in oracle database?

543

---

What is transaction control statement and how many types of transaction control statement in Oracle?

562

---

What is a nvl function? How can it be used?

561

---

What happens if the imported table already exists?

549

---

What is a partition in oracle?

545

---

How do you store pictures in a database?

563

---

What are the different types of partitions in oracle?

496

---

What is a read write transaction in oracle?

604

---