Answer Posted / sujitha

For Example TableName: Employee. Employee Have The
Following Fields.
Emp_No ( Identity Value)
Emp_Name
Designation



Select Top 1 * From Employee Where Emp_No Not in(Select
Top 24 Emp_No From Employee)

What are transactions in sql?

1049

---

How do I start sql server 2017?

927

---

How you can get a list of all the table constraints in a database?

947

---

what is denormalization? : Sql server database administration

917

---

How to use user defined functions in expressions?

1073

---

How do I find the default sql server instance?

931

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

970

---

List out what other servers you can use with ssrs?

137

---

How will you go about resolving deadlocks?

960

---

Can we perform backup restore operation on tempdb? : sql server database administration

986

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1066

---

Explain what are commit and rollback in sql?

922

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2470

---

What is a heap?

1026

---

How to find Duplicate Records In table?

1007

---