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 is attribute? : sql server analysis services, ssas

981

---

Explain system functions or built-in functions? What are different types of system functions?

917

---

What is RAID? What are the different types of RAID configurations?

1066

---

Can sub report data source be different from that of the parent report?

135

---

How to transfer a table from one schema to another?

940

---

What is logshipping and its purpose?

945

---

What is user-defined function?

916

---

How to Sync Two SQL Azure Databases?

119

---

What is partition index in sql server?

1049

---

When columns are added to existing tables, what do they initially contain?

978

---

Explain log shipping and mention its advantages.

990

---

What is use of except clause? How it differs from not in clause?

974

---

which backup strategy you are following at ur company

2103

---

How to delete duplicate rows in sql server?

1057

---

Different types of keys in SQL?

1034

---