how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

How do sql databases work?

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---

---

what is overloading procedure or overloading function ?

3 Answers   Genpact,

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

What is keys and its types?

0 Answers  

---

how to get a list of all tables in a database? : Sql dba

0 Answers  

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

What is constant in pl sql?

0 Answers  

---

What can you do with pl sql?

0 Answers  

---