Answer Posted / vikas kant

select Top 1 salary from emp_Table where salary in(select
Top 2 Salary from emp_Table order by salary desc)

When would you use sql joins?

1029

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1073

---

What is a functions and types in sql server?

1148

---

What is the difference between substr and charindex in the sql server?

1187

---

How network traffic be reduced by using the stored procedure?

1172

---

Do you know spatial data types - geometry and geography in sql server 2008?

1092

---

How to invoke a trigger on demand?

1151

---

What are the benefits of filtered indexes?

1096

---

What is Transparent Data Encryption?

1061

---

What are the differences between local and global temporary tables?

1132

---

Which sql server is best?

1050

---

What command must you use to include the not null constraint after a table has already been created?

1235

---

Explain triggers in sql?

1003

---

What is set nocount on and what is set nocount off?

995

---

What is a data source or ds? : sql server analysis services, ssas

1052

---