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

How to rename databases in ms sql server?

1209

---

What does the update command do?

1117

---

What are rest-style architecture's?

172

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1139

---

Explain syntax for disabling triggers?

1046

---

How to list all login names on the ms sql server?

1147

---

What is the difference between online clustering and Offline clustering?

2419

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1018

---

How would we use distinct statement? What is its use?

1075

---

What is the difference between dataadapter and datareader?

1012

---

What the different types of Replication and why are they used?

1075

---

What is the difference between ddl,dml and dcl commands?

1116

---

What is multilevel indexing?

935

---

What is a transactions?

1045

---

Describe triggers features and limitations?

993

---