Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

What is the advantage of nosql?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

What is dynamic query?

0 Answers  

---

Can we group by two columns in sql?

0 Answers  

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

---

What are sql objects?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---