i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

How do I create a sql script?

0 Answers  

---

What is the difference between sql and mysql?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What is the purpose of the partition table?

0 Answers  

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

What are the constraints available in sql?

0 Answers  

---

How to write a query to show the details of a student from students table whose

0 Answers  

---

What is pivot table in sql?

0 Answers  

---

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

---

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---