Answer Posted / subhranghshu bhattacharjee

first find second largest salary in the emp database:

select min(sal)sal from(select sal from emp order by sal
desc)
where rownum<3
u can find 3rd,4th... so on ,only change rownum
like rownum<4,rownum<5 ... so on

What do you understand by recursive stored procedures?

941

---

Write a query to find 5th highest amount paid from the customer table.

881

---

Mention the differences between sql server and mysql.

950

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951

---

What is schemabinding a view?

866

---

Explain for xml explicit mode?

913

---

How can I know what locks are running on which resource?

901

---

What is a with(nolock)?

928

---

mention different types of relationships in the dbms?

964

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

853

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1004

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

898

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

880

---

What are the restrictions that views have to follow? : SQL Server Architecture

948

---

Is it possible to call a stored procedure within a stored procedure?

917

---