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

What are number line correlation administrators will use while working with a subquery?

836

---

What is sql collation?

828

---

How to transfer data from a cursor to variables with a "fetch" statement?

767

---

How can you check the version of sql server?

775

---

What is bcp? When does it use?

671

---

---

What are the disadvantages of merge replication?

967

---

List the different types of collation sensitivities in sql server?

727

---

mention different types of relationships in the dbms?

699

---

What are the types of lock supported by ?

781

---

What are the differences between union, intersect, and minus operators?

761

---

List some of the rules that apply to creating and using a ‘view’

673

---

What are the differences between substr and charindex in sql server.

690

---

Can you explain what is sql server english query?

726

---

what is unique and xaml nonclustered index

774

---

How to find the version of sql server? : sql server database administration

809

---