Answer Posted / lince

select * from(select salary,dense_rank() over(order by salary desc) as rno from emp)T where T.rno=6

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

926

---

Is there any difference between the primary key and unique key?

951

---

Explain primary key?

902

---

Explain how does the report manager work in ssrs?

903

---

how many type of indexing in database?

937

---

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

957

---

List the ways in which dynamic sql can be executed?

972

---

What is a rollup clause?

910

---

Explain having clause?

911

---

how can you attach more than 20 ldf files in sql server

1949

---

What do you mean by an execution plan? Why is it used?

954

---

What do you mean by acid?

938

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2266

---

How to count duplicated values in a column in ms sql server?

999

---

Explain the use of containers in ssis and also their types?

912

---