Answer Posted / dewashish kumar pal

Select max(salary) from tablename where salary not in (select max(salary) from tablename);

How do I start sql server 2016?

916

---

Difference between primary key and clustered index?

1014

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

977

---

How to make a column nullable?

1125

---

What is a trigger what are the advantages of trigger?

1004

---

What are the new security features added in sql server 2012? : sql server security

1030

---

What Are the Main Features of SQL Azure?

117

---

can an automatic recovery be initiated by a user? : Sql server administration

959

---

Does a full backup include transaction log?

981

---

What is the difference between deallocate cursor and close cursor?

1266

---

What is difference between getdate and sysdatetime in sql server 2008?

1056

---

Describe and explain about SQL native client?

1113

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1011

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1078

---

What is sqlcmd?

1062

---