Answer Posted / pradip jain

Select * from marks where
(Math=(select min(Math)from
marks) and phy=(select min(phy) from marks))
OR
(Math=(select min(Math)from
marks) and chem=(select min(chem) from marks))
OR
(Phy=(select min(phy)from
marks) and chem=(select min(chem) from marks))


Sonia if it is 3 subject and will be combine with or clause

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1055

---

What is database white box testing?

1173

---

List out the differences between the clustered index and non-clustered index in sql server?

1047

---

What is exclusive locks?

1009

---

How to use the inserted and deleted pseudo tables?

1001

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1016

---

Explain the xml support sql server extends?

1079

---

What is row-level compre?

1049

---

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

1020

---

How to delete existing triggers using "drop trigger"?

1096

---

How do I open port 1433?

982

---

What is the difference between a check constraint and a rule?

1345

---

How to convert numeric values to integers in ms sql server?

1156

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

990

---

What is system stored procedures?

1080

---