Answer Posted / ramakrishna

select e1.* from emp e1 where n=(select
count(distinct(e2.sal)) from emp e2 where e1.sal<=e2.sal);

What is sql server schema compare? How we can compare two database schemas?

1084

---

what's the information that can be stored inside a bit column? : Sql server database administration

1091

---

Is mysql the same as sql server?

1033

---

What’s the use of custom fields in report?

988

---

Write a query for primary key constraint with identity key word?

1084

---

What is the index requirement in SQL Azure?

98

---

What is advantage data architect?

977

---

What are sp_configure commands and set commands?

1076

---

How to create “dependant” parameter “make, model, year”

137

---

Which tcl commands are available on the sql server?

1143

---

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

1079

---

What extended events?

1062

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1135

---

Explain multiserver query

1113

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1802

---