Question { 11116 }
What are the components of a PL/SQL block ?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 12155 }
how to retrieve only duplicate values in a table
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 4388 }
in sql table following column r there
i want find 1st paid ,2nd paid,3rd paid date for same
|service_type|date |vehicle_no|
|------------|------|_---------|
|paid |23 jan|MH12H2007 |
| | | |
|paid |26 feb|MH12H2007 |
| | | |
| | | |
|paid |28 mar|MH12H2007 |
i want o/p like below
vehicle no| 1st paid date | 2nd paid date|3rd paid |latest
paid date|
pls help me out
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
Answer
Is This Answer Correct ? | 0 Yes | 0 No |