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 is log shipping?

962

---

how you can list all the tables in a database?

1013

---

What are indexes in sql?

1249

---

Explain the database you used in your final year project?

1019

---

Can you get second highest salary from the table?

947

---

what is blocking? : Sql server database administration

1015

---

Write an sql query to find first weekday of the month?

900

---

What is 'Join' and explain its various types.

1117

---

What happens if null values are involved in bitwise operations?

994

---

How to compare the top two records using sql?

1327

---

Tell me what do we need queues in sql service broker?

971

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1011

---

Explain different types of locks in sql server.

1064

---

What is the purpose of the master database?

1104

---

How to assign new column names in a view?

909

---