Answer / Ashwini Kumar

To filter records from a table in SQL Server, you can use the WHERE clause:nn```sqlnSELECT * FROM YourTable WHERE columnName = 'value';```nReplace 'YourTable' with the actual name of your table, 'columnName' with the name of the column to filter, and 'value' with the desired value for that column.

What is trigger explain with program?

1 Answers  

---

What is Left Outer Join?

2 Answers  

---

what is database replication? : Sql server database administration

1 Answers  

---

Difference between DELETE and TRUNCATE?

1 Answers   Atos, TCS,

---

How to generate create view script on an existing view?

1 Answers  

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

How to select some specific rows from a table in ms sql server?

1 Answers  

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---

How many databases instances are there in sql server 2000?

1 Answers  

---

Why we should not use triggers?

1 Answers  

---

Do you know what are various aggregate functions that are available?

1 Answers  

---