Answer Posted / mohan c v

select min(salary) from
(select top 2 salary from phani order by salary desc) as a

What is faster join or union?

590

---

What is b tree index?

502

---

Difference between 2NF &3NF ?

671

---

How dts is used to extract, transform and consolidate data?

584

---

What are the database roles? : sql server security

552

---

---

What are information schema views?

539

---

How can I tell if sql server is 32 or 64 bit?

490

---

Where are sql server user names and passwords stored in sql server?

520

---

what is unique and xaml nonclustered index

550

---

What is inline table-value user-defined function?

576

---

What are the hotfixes and patches in sql server?

538

---

What does man by sql wildcard characters in sql server?

509

---

What is cursors?

634

---

How to display a past time in days, hours and minutes?

561

---

When would you use a before or after trigger?

480

---