Answer Posted / sameera chiluka

select secondMAXsal from emp
WHERE seconMAXsal = ((MAXsal)-1);

Can two tables share a primary key?

518

---

Where do you find the default Index fill factor and how to change it?

603

---

What is the difference between index seek vs. Index scan?

580

---

What triggers long term care?

562

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

547

---

---

Explain the xml support sql server extends?

622

---

Explain the different types of joins?

570

---

What is sql server used for?

556

---

What are the differences between char and nchar in ms sql server?

537

---

Tell me about builtinadministrator?

562

---

We need to perform what steps in the following order to work with a cursor?

712

---

Does union all remove duplicates?

609

---

Why do we use trigger?

556

---

How to find Duplicate Records In table?

587

---

Equi join and non equi join is possible with sql server?

487

---