query to find the maximum no persons with same age(age colomn) from emp t

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Databases >> Oracle >> Oracle General

Question

query to find the maximum no persons with same age(age 
colomn) from emp table

Question Submitted By :: Srinu

Rank

Answer Posted By

Re: query to find the maximum no persons with same age(age colomn) from emp table

Answer
# 1

select max_age,age
from
(select count(age) max_age,age from emp group by age order 
by max_age desc)
where rownum < 2

Is This Answer Correct ?

0 Yes

0 No

Krishnakumar

Question	Asked @	Answers
Other Oracle General Interview Questions


Describe Referential Integrity ?		1
What is Normalization ?	Keane-India-Ltd	7
What is a data segment ?		1
what is cartesian product?		2
What is STATSPACK tool?	Wipro	1
what is load balancing and what u have used to do this?(sql loader)		1
What is an Index Segment ?		1
What are the trigger associated with image items ?	Oracle	1
pls explain connect by prior with example and its real time use		2
what is the syntax of DELETE command?		3
What is a cluster?		1
What is an Integrity Constrains ?		1
What is a View ?		3
Maximum how many triggers can be updated in table ?	Accenture	4
what is the output of select * from emp where null=null & select * from emp where 1=1		5
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?	ESS	1
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X		1
How to define Data Block size ?		1
what is the syntax of INSERT command?		5
Can objects of the same Schema reside in different tablespaces.?		1

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