Answer Posted / avanish kumar

if you have a table emp and you have to find fourth maximum
salary from emp table then you will have to write this
query.....

select top 1 sal from (select top 4 * from emp order by sal
desc) as sal order by sal

Explain the various types of concurrency problem?

1136

---

How to identify current user in ssrs report?

390

---

How to use copy and concatenate commands in SQL?

1064

---

What are rest-style architecture's?

170

---

Do you know the isolation level that sql server support?

921

---

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

948

---

do views contain data ?

912

---

What are the different types of locks in the database?

872

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

942

---

What are the different types of lock modes in sql server 2000?

882

---

Explain powershell included in sql server 2008?

999

---

How to delete all rows with truncate table statement in ms sql server?

930

---

What is the significance of null value and why should we avoid permitting null values?

915

---

How to drop an existing user defined function in ms sql server?

980

---

What is database mirroring?

1038

---