Answer Posted / chandra sekhar

select min(salary) from emp where salary in (select top n salary from emp order by salary desc)

How do I view views in sql server?

941

---

What is default constraint?

936

---

Can we shrink data file in sql server?

1000

---

What is blocking?

984

---

what are user defined datatypes and when you should go for them? : Sql server database administration

964

---

role of sql sever 2005 in database rather than any other database

1889

---

How to create new table with "create table" statements?

998

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

954

---

How do I find the sql server instance name?

922

---

Can two tables share the same primary key?

858

---

Define candidate key, alternate key, and composite key.

874

---

What is schemabinding a view?

866

---

How many types of functions are there in sql server?

878

---

What is transaction server isolation?

978

---

What command do we use to rename a db, a table and a column?

876

---