Answer Posted / ravikiran

select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary

What protocol does sql server use?

519

---

How to set the current database in ms sql server?

532

---

What Is Rdbms?

673

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100

---

How to modify the underlying query of an existing view?

535

---

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1489

---

Define Joins?

612

---

What is merge join?

576

---

How to get a list of all tables with "sys.tables" view in ms sql server?

551

---

What are window functions in sql server?

513

---

Explain left outer join and right outer join?

559

---

what is the different types of backups available in sql server? : Sql server database administration

499

---

Does the unique constraint create an index?

566

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

573

---

What is role playing dimension with two examples? : sql server analysis services, ssas

590

---