consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

---

What is tns service name?

0 Answers  

---

what is the difference between substr and instr function in oracle?

0 Answers  

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

Explain the difference between a procedure and a function?

0 Answers  

---

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

---

Is oracle a relational database?

0 Answers  

---

How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  

---

What is the database name in oracle?

0 Answers  

---

Can you create a synonym without having a table?

0 Answers  

---