Answer Posted / rakesh

In Oracle

select marks from
(select marks from
(select marks from students order by marks desc)
where rownum<3
order by marks asc)
where rownum<2

What are system databases into sql server (2005/2008) : sql server database administration

1011

---

Mention the different authentication modes in sql server.

1051

---

How do I find the default sql server instance?

943

---

Can you get second highest salary from the table?

964

---

What are the advantages of sql azure?

140

---

what is the sql equivaent of the dataset relation object ?

2026

---

1 01 101 01010

2054

---

What is auditing in sql server?

927

---

How do you know if sql server is running on your local system?

1040

---

How do I start and stop sql server?

1020

---

What is a filestream?

991

---

What is store procedure? How do they work?

1020

---

Do you know what is fill factor and pad index?

1002

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1049

---

What is Dependency Injection and provide example?

1117

---