Answer Posted / parmesh m

select top 1 salary from Employee where salary in (
select top n salary from Employee
group by salary
having count(salary )< n+1
order by salary desc )
order by salary

What is @@error in sql?

1106

---

What is oltp (online transaction processing)?

1057

---

What is a dbms wizard?

1074

---

What is rs.exe utility?

162

---

What is the stuff and how does it differ from the replace function?

1224

---

Is null in sql server?

1041

---

How to concatenate two character strings together?

1166

---

What is bit data type?

1081

---

What is table join?

1170

---

Describe the left outer join & right outer join. : sql server database administration

1036

---

How to verify a login name with sqlcmd tool?

1263

---

What are the new scripting capabilities of ssms? : sql server management studio

1118

---

What are the differences between char and nchar in ms sql server?

1140

---

What is the purpose of the model database?

1065

---

Can we linked SharePoint to a SQL database?

1073

---