1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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


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

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

Why do we use sql constraints?

0 Answers  

How to fetch records from a partitioned table?

2 Answers   HSBC,

what are the 'mysql' command line arguments? : Sql dba

0 Answers  




How do you add a column to a table?

0 Answers  

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

how can i read write files from pl/sql

3 Answers  

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

What is clause in sql?

0 Answers  

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

For more SQL PLSQL Interview Questions Click Here
Categories