Answer Posted / nancy singhal

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

Explain character-manipulation functions?

636

---

How many sql are there?

522

---

What is replication id?

524

---

What is pivot query?

598

---

What is db journal file?

524

---

---

Explian rowid, rownum? What are the psoducolumns we have?

576

---

What are the possible values for the boolean data field?

527

---

What is the difference between sql and t sql?

542

---

Is clustered index a primary key?

537

---

What kind of join is join?

561

---

How do I add a primary key to a table?

547

---

What are primary key and foreign key and how they work?

557

---

Is join and inner join the same?

543

---

What are operators available in sql?

593

---

What is difference between sql function and stored procedure?

508

---