Answer Posted / harikumar

select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)

What is the difference between truncate and delete commands?

1005

---

Is a primary key unique?

941

---

What is a trigger what are the advantages of trigger?

917

---

What are the steps to process a single select statement?

889

---

How to delete a database in ms sql server?

1120

---

What are the new features of sql server 2008 r2 reporting service?

193

---

What do you understand by hotfixes and patches in sql server?

916

---

What is a data source file?

925

---

What is normalization and its types?

966

---

what are the three command line utilities and what are their primary functions?

136

---

Why does sql studio use a single registered database repository? : sql server management studio

956

---

What happens if you are trying to access a schema not owned by you?

914

---

can a database be shrunk with users active? : Sql server administration

953

---

When would you use it?

945

---

How can I tell if sql server is 32 or 64 bit?

903

---