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  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Cognos
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
write a query to display to 10 max record from the employee
table?
 Question Submitted By :: Sekhar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: write a query to display to 10 max record from the employee table?
Answer
# 1
select * from emp x where &n=(select count(distinct sal) 
from emp y where x.sal<=y.sal)

it will prompt for the value give the values as 10 u will 
get the output
 
Is This Answer Correct ?    0 Yes 0 No
Narender.v
 
  Re: write a query to display to 10 max record from the employee table?
Answer
# 2
select * from emp a
where (select count(distinct sal) from emp b where
a.sal<b.sal)=&n order by sal desc
/


this is the exact query........when there are duplicate
salaries are there also........
 
Is This Answer Correct ?    0 Yes 0 No
Madhoo
 
 
 
  Re: write a query to display to 10 max record from the employee table?
Answer
# 3
To find nth value

select salary from emp a where &n=(select count(distinct
salary) from emp b where a.empno<=b.empno);

to find max by nth value a.empno<=b.empno
to find min by nth value a.empno>=b.empno

OR

To find 10 max records 

select * from (select * from emp order by salary desc) where
rownum<=&n;
 
Is This Answer Correct ?    0 Yes 0 No
Rajasivam.p
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
what are the components having in the report studio using interface eg:insertable objects pan,properties pan HCL1
what is Cognos Visualizer?  1
how u migrate the reports from impromptu to reportnet??? Wipro3
Which service handles requests for cognos connection,query studio and event studio. TCS1
What is the importance of Dimension in the cognos. Hexaware3
what r the claims? how many type of claims we face from client side?  1
15. If I select the current month and year how can we display previous 11 months data? TCS1
How can we find out cardinality between two tables? Dominion2
what is an sid (surrogate key)? IBM1
what is your project workflow and your role in the project? Syntel1
Difference betwween cognos report net architecture and cognos8 architecture  3
Can we create a web page where the report directory and the output can be viewed directly across cognos connection? TCS1
What is the difference between macros and prompt?  2
Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !  3
Column level security in report  3
What are the Ways to Import Data into Catalong?  1
if there are list,crosstab,chart how can you apply a single filter to all object? Syntel1
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way? Logica-CMG5
What is architectue of Cognos 8  2
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?  1
 
For more Cognos Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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