ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
consider some table with 4 r 5 columns in that 1 col is 
DATE type. The data is like that,For each date in that col 
some 3 fields r there but all the records r having 
different data. Now i want to display all the columns by 
performing grouping on the date field ( as SELECTION 
Operator(*) cannot be used with group function having only 
one "group by clause". how to do this? can any one help me 
in finding out the solution plss?
 Question Submitted By :: Swathi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
Answer
# 1		 
First of all you need to understand that purpose of 
grouping.
Group by is used when you need to club a few columns on the 
basis of one column, for this you need to use some 
aggregate functions,

for eg. for a table test
a       b       c
1	2	29-JUN-08
1	4	29-JUN-08
3	5	04-JUL-08
13	15	05-JUL-08

you can group a and b on c as follows:-
select count(a), max(b), c from test
group by c
count(a)max(b)  c
2	4	29-JUN-08
1	5	04-JUL-08
1	15	05-JUL-08
 
Is This Answer Correct ?    0 Yes 0 No
Mukti Singh
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
Can a property clause itself be based on a property clause ? Oracle1
What is a Tablespace?  1
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks  1
What is a Public Synonyms ?  1
how many columns can a plsql table have NIIT4
What is a Data File ?  1
what is cartesian product?  2
what are pseudocolumns?  4
structural difference between bitmap and btree index ? Infosys1
What are the type of Synonyms?  1
The join defined by the default data link is an outer join yes or no ? Oracle1
when do u go for hash partitioning?  1
What is Trace File ? Thermotech4
what are indexes..how many types of index's are there and what are they? TCS4
What is SAVE POINT ?  2
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?  1
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?  3
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?  1
What are the factors causing the reparsing of SQL statements in SGA?  1
how will I find the first 5 highest salaried employees in each dept in oracle. IBM6
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com