How to get nth highest salary from employee table.

0 Answers  

---

Define full outer join in sql server joins?

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

where can you add custom error messages to sql server? : Sql server administration

0 Answers  

---

What is the temp table?

0 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

What is a stored procedure?

3 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---