Answer Posted / dewashish kumar pal

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

Is it ok to shrink transaction log?

939

---

What is the cpu pressure?

994

---

what are the different types of replication you can set up in sql server? : Sql server database administration

971

---

What is model database in sql server?

1004

---

Explain tablesample?

948

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

871

---

Do you know what is rank function?

1035

---

What is sql server transaction log file?

994

---

Differentiate between a local and a global temporary table?

900

---

What is function of CUBE ?

971

---

What command is used to delete a table from the database in the sql server and how?

1043

---

What is the purpose of the tempdb database?

960

---

Can multiple columns be used in sql group by clause in ms sql server?

988

---

Can an entity have two primary keys?

927

---

What is index in an assignment?

894

---