Answer Posted / ritesh sabanis

select max(sal) from employeedata where sal <
(select max(sal) from employeedata where sal not in(select
max(sal)from employeedata)) ;

How many joins in sql?

560

---

How do temporal tables work?

521

---

Why we use cross join?

543

---

explain advantages of myisam over innodb? : Sql dba

609

---

What is pls_integer in pl sql?

545

---

---

How is data stored on a disk?

546

---

how to create a new view in mysql? : Sql dba

503

---

How can I tell if sql is running?

593

---

Does pl sql work in mysql?

538

---

What is the sql case statement?

581

---

How subquery works in sql?

545

---

What is raw datatype in sql?

558

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

650

---

What are % type and % rowtype?

578

---

What is difference between hql and sql?

512

---