Answer Posted / jaishree singh

select emp_name,salary from
(select emp_name,salary, row_number() over (order by salary)
rownumber from employee) E
where E.rownumber = 3

What are indexers?

1091

---

What are the advantages of paper records?

971

---

How to download and install microsoft .net framework version 2.0?

1143

---

Can we use trigger new in before insert?

927

---

What is unpivot?

1017

---

Do you know what is lock escalation?

1016

---

Explain difference between control flow and data flow?

971

---

How to drop an existing table with "drop table" statements in ms sql server?

1090

---

what are the disadvantages of cursors? : Sql server database administration

1031

---

What are data driven subscriptions?

115

---

What do you understand by recursive stored procedures?

994

---

How to find the source of a table in sql server?

1000

---

How to use copy and concatenate commands in SQL?

1145

---

What are the two authentication modes in sql server?

1126

---

How many types of the database links?

1073

---