Answer Posted / monty

i have other idea if there is no duplicate record in the
table you can use this


select top 7 *from employee
except
select top 4 *from employee

What is a result set object returned by mssql_query()?

576

---

Explain table valued parameters in sql server? Why tvp used?

555

---

What is an identity column in insert statements?

581

---

what is normalization? Explain different levels of normalization? : Sql server database administration

652

---

How to populate a table in sql server?

502

---

---

How to count duplicated values in a column in ms sql server?

514

---

What are the different types of cursor?

603

---

Which are the third-party tools used in sql server and why would you use them?

492

---

Can we add our custom code in ssis?

545

---

Find nth lowest salary or get nth lowest salary?

593

---

What is the chart in report?

111

---

Why do we use non clustered index?

551

---

What is normalization process?

597

---

Are all views updatable ?

721

---

What is difference between index seek vs. Index scan?

623

---