Where the Pre_defined_exceptions are stored ?

2 Answers  

---

When are we going to use truncate and delete?

0 Answers  

---

Is there any restriction on the use of union in embedded sql?

0 Answers  

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

Why do we need unique key in a table?

0 Answers  

---

How do I save a stored procedure?

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

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 find second highest salary of an employee.

27 Answers  

---