Answer Posted / sanjay

create table test(id int identity,marks int)
insert into test
select 20
union all
select 31
union all
select 33
union all
select 1
union all
select 3
union all
select 100
union all
select 88

select * from test


with data as
(
select marks,row_number() over(order by marks desc) as rno
from test
)
select * from data where rno = 3

how you can deploy an ssrs report?

127

---

How does a profiler work?

514

---

What is a recursive stored procedure in sql server?

571

---

How do I create an extended event in sql server?

489

---

How will you add a dimension to cube? : sql server analysis services, ssas

556

---

---

What is scalar user-defined function?

552

---

Can we shrink data file in sql server?

539

---

Explain different types of lock modes in sql server 2000?

521

---

How to get a list of columns using the "sys.columns" view in ms sql server?

560

---

What is policy management?

579

---

How do we know if any query is retrieving a large amount of data or very little data?

552

---

Explain the properties of a relational table?

561

---

Explain the microsoft sql server delete command? : SQL Server Architecture

582

---

How to use wildcard characters in like operations in ms sql server?

600

---

How connect excel to sql server?

508

---