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)) ;

what are the different index configurations a table can have? : Sql dba

575

---

how mysql optimizes distinct? : Sql dba

553

---

What are the constraints available in sql?

580

---

What is partition by in sql?

569

---

explain advantages of myisam over innodb? : Sql dba

601

---

---

What is the difference between join and natural join?

473

---

What is a unique key and primary key and foreign key?

567

---

When can we use the where clause and the having clause?

578

---

Is join and inner join the same?

541

---

Is it possible to read/write files to-and-from PL/SQL?

653

---

What is pivot query?

596

---

How to rename a column in the output of sql query?

539

---

Explain how to use transactions efficiently : transact sql

529

---

What is coalesce in sql?

563

---

What is function and procedure?

567

---