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 is data source view or dsv? : sql server analysis services, ssas

1065

---

How secure is sql server database?

1068

---

Can two different columns be merged into single column? Show practically?

1124

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2076

---

What is sql server database?

1082

---

What are the types of stored procedures in an sql server?

1036

---

Explain what are various ways to enhance the ssrs report?

1098

---

What is the full form of dql?

1028

---

Where are SQL server users names and passwords are stored in sql server?

1330

---

How many types of stored procedures are there in sql server?

1060

---

How to configure odbc dsn with different port numbers?

1154

---

What new changes are being made in SQL Server?

1271

---

How to make conditional sum in ssrs?

183

---

What is trigger explain with program?

1019

---

What are different type of Collation Sensitivity?

1052

---