Answer Posted / ravindra babu

select sal from (select sal from(Select distinct sal from
EMP order by sal desc)Where rownum <=2 order by sal asc)
Where rownum=1;

How to get a list of columns in a view using the "sp_columns" stored procedure?

988

---

How to create indexed view?

987

---

Why truncate is ddl?

1030

---

What is TDS(Tabular Data Stream) Gateway?

121

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

913

---

What is xml datatype?

1035

---

How to get a list all databases on the sql server?

1027

---

What are different types of statements that are supported by sql?

984

---

What is use of @@ spid in sql server?

1149

---

Explain having clause and where clause?

992

---

Explain what is it unwise to create wide clustered index keys?

932

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

982

---

What is transaction server isolation?

978

---

What is nonclustered index with included columns ?

908

---

Why functions are used in sql server?

898

---