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

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

121

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1061

---

What is the federation in sql azure?

97

---

Explain what are the different index configurations a table can have?

1116

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3880

---

How to create indexed view?

1050

---

How do I find the sql server database version?

1015

---

What is the openxml statement in sql server?

1078

---

Explain partitioned view?

1092

---

Why use “pivot” in sql server?

1126

---

List the different types of joins?

1015

---

Explain the properties of a relational table?

1027

---

What do you need to connect php to sql server?

1112

---

List the different index configurations possible for a table?

937

---

What is a join in sql? What are the types of joins?

1112

---