Answer Posted / avinash

declare @n;
set @n = N
select * from tbl
where @n in (
select dense_rank over (order by salary) as rank_sal
from tbl )

What do you understand by mirroring?

952

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1991

---

What is a derived table?

872

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

---

System requirements for sql server 2005 express edition?

954

---

What happens if we shrink log file in sql server?

913

---

How will you hide an attribute? : sql server analysis services, ssas

893

---

How do I port a number to sql server?

983

---

How to get all stored procedures in sql server?

939

---

What is postgresql server?

943

---

What is sql server profiler?

957

---

What is difference between oltp and olap?

984

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

---

List the ways in which dynamic sql can be executed?

972

---

How do I start sql server 2017?

888

---