3. Select sum(a) sum_1,max(a) max_1 ,count(a) count

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all
Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Question Posted / sudarshanbehera07@gmail.com

1 Answers
3151 Views
Fintellix, I also Faced
E-Mail Answers

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Se..

Answer / sudarshanbehera07@gmail.com

Ans: sum_1 max_1 count_1
2014 2011 3

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

package specification-3 procedures package body-2 procedures will is execute

2 Answers PWC,

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers

What is data type in database?

0 Answers

How do I run pl sql in sql developer?

0 Answers

I have a CURSOR then why we need BULK COLLECT again?

1 Answers

Which table is left in left join?

0 Answers

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.

4 Answers GE,

Give the structure of the procedure ?

1 Answers

How do you update a sql procedure?

0 Answers

What is a primary key sql?

0 Answers

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers INDUS,

For more SQL PLSQL Interview Questions Click Here