Can a table contain multiple primary key’s?

0 Answers  

---

Which are the different case manipulation functions in sql?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

What mean sql?

0 Answers  

---

Is a table valued function object?

0 Answers  

---

Explain alias in sql?

0 Answers  

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

Mention what does plv msg allows you to do?

0 Answers  

---

What is pl/sql table? Why is it used?

0 Answers  

---

What is procedure and function in sql?

0 Answers  

---