Answer Posted / subhranghshu bhattacharjee

another way u can find 2nd largest salary,3rd largest
salary ... so on

select sal from(select sal from emp order by sal desc)
where rownum<3
minus
select sal from(select sal from emp order by sal desc)
where rownum<2

only change rownum to find various largest salary

Subhranghshu Bhattacharjee

What are different types of data sources?

1084

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1064

---

What is normalization? Explain different forms of normalization?

1230

---

what are triggers? : Sql server database administration

954

---

How to create an index on a view?

1141

---

How to automatically create a log when an exception is being received into SQL Server?

1360

---

Write a SQL query to make a column as unique?

1078

---

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

1995

---

How to create dbo table in sql server?

1006

---

what is unique and xaml nonclustered index

1101

---

Explain what is the difference between union and union all?

1070

---

What is dbcc?

1180

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1130

---

What is page in sql server?

996

---

What is side by side migration in sql server?

1173

---