Answer Posted / nidhish

replace the N with wat ever number u want

select min(salary) from employee where salary in ( select
distinct top N salary from employee order by salary desc)

Define left outer join?

975

---

Does index speed up select statements?

1017

---

What is an identity column in insert statements?

1027

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1686

---

How to grant a permission in ms sql server using "grant execute" statements?

1097

---

What is indexing explain it with an example?

1016

---

What is extent? Types of extents?

1199

---

Explain can SSRS reports Cache results?

160

---

What is an example of a primary key?

994

---

Does hive support indexing?

968

---

How to insert data with null values?

1040

---

Explain how dts is used to extract, transform and consolidate data?

1001

---

What is 2nf example?

1001

---

What is difference between index seek vs. Index scan?

1161

---

What is the purpose of update statistics and scope_identity() function?

1101

---