Answer Posted / sonia

create table student7(Roll int,English int,Hindi int,Maths
int)
insert into student7 values(1,12,15,9)
insert into student7 values(2,23,3,13)
insert into student7 values(3,15,12,4)

select roll from student7 where
maths=(select min(maths) from student7)
AND
English=(select min(english)from student7)

Rajesh, AND Operator is used b/w two conditions . Answer
given by you is limted to two subjects, if there are three
or more subjects then

Define ACID properties in a Database?

710

---

What is sub-query in sql server?

775

---

What is built-in/administrator?

652

---

What are the types of database recovery models?

680

---

What is report snapshot?

113

---

---

How to make a column nullable?

681

---

Where are sql server user names and passwords stored in sql server?

627

---

Is ssrs support other database except ms sql server?

98

---

Define clusters?

732

---

How to delete duplicate rows in sql server?

668

---

What is sql server locking?

622

---

Explain what is analysis service repository?

634

---

What is ssl in sql server?

632

---

What is SQL Azure Federations?

106

---

Tell me about joins in database system and explain each in detail.

696

---