Answer / bhavya

It will common records from both the table

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

how view used for security purposes?

3 Answers   Glam India,

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

What is a pl/sql block?

0 Answers  

---

Is big data nosql?

0 Answers  

---

what is csv? : Sql dba

0 Answers  

---

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.

2 Answers   Oracle,

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

Does normalization improve performance?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---