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

Tell me what are the advantages of using stored procedures?

1062

---

How can you insert null values in a column while inserting the data?

1340

---

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

1188

---

How to identify current user in ssrs report?

408

---

What is the difference between local and global temporary tables?

1193

---

What are different types of table joins?

1051

---

Explain the database you used in your final year project?

1099

---

What are trace files?

1004

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1040

---

What are the results of running this script?

974

---

Who is the owner of a schema in ms sql server?

1116

---

How do I start sql server agent automatically?

1021

---

What is 2nf in normalization?

1054

---

Can one drop a column from a table?

1067

---

List the different types of collation sensitivities in sql server?

1074

---