Answer Posted / smitam

select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC

Do you know what is normalization of database? What are its benefits?

1061

---

What are the types of database recovery models?

1074

---

What do you mean by normalisation?

989

---

What is logshipping and its purpose?

959

---

Write a query for primary key constraint with identity key word?

991

---

How to use "begin ... End" statement structures in ms sql server?

985

---

Do you know the capabilities of cursors?

1098

---

Determine how to use the inserted and deleted pseudo tables?

951

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1117

---

What is the largest component inside a field?

1064

---

How to use subqueries with the exists operators in ms sql server?

1079

---

How do I shrink an ldf file?

952

---

What is query optimization process?

962

---

what is a sub-report?

137

---

what are constraints? : Sql server database administration

1005

---