Answer Posted / harikumar

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

what is blocking? : Sql server database administration

1015

---

Do you know data definition language, data control language and data manipulation language?

1023

---

Explain stored procedure?

1030

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

917

---

What is the difference between local and global temporary tables?

1126

---

What is microsoft sql server?

956

---

What is a collation in ms sql server?

1057

---

Where sql server usernames and passwords are stored in a sql server?

970

---

How to create indexed view?

1026

---

What is resource governor in sql server?

974

---

What is the purpose of sql profiler in sql server? : sql server database administration

1085

---

Explain what is the function of sql server agent windows service?

980

---

What is a transactions?

1027

---

Explain security with sql azure?

186

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1891

---