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   SiteMap shows list of All Categories in this site.
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
To display first 10 records we can write the query as 
select * from(select * from emp order by ename desc) where
ronum<=10;
 
Is This Answer Correct ?    0 Yes 0 No
M M Naidu
 
  Re: write a query to display to 10 max record from the employee table?
Answer
# 2
You are question is not clear.....you need decide based on
which column you want first 10 records.....

if you work on Salary column this is the query .......

select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/

Any queries on Sql please feel free to ask me i am very
interest in it......
 
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
Select Max(Count=10) from emp a
 
Is This Answer Correct ?    0 Yes 1 No
Richard
 
  Re: write a query to display to 10 max record from the employee table?
Answer
# 4
select * from(select rownum r,emp.*from emp order by sal 
desc) where r<=10;
 
Is This Answer Correct ?    0 Yes 0 No
Srinu
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
what are determinants? Dominion1
how u provide security in power play transformer??? iFlex1
what r the claims? how many type of claims we face from client side?  1
What are the different ways of adding data in Transformer?  1
How will you migrate your reports to QA environment? Satyam2
1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm? CTS1
what is mean by cognos powerhouse?  1
Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting TCS2
what is the difference b/w mdx and sql? Cap-Gemini2
Difference between cognos report net and cognos8  1
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?  3
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com IBM1
How to create a dynamic column name in Cognos? Polaris5
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
How to pass multiple values from picklist prompt to sub report filter? Infosys2
what is stitch query? Syntel1
what is the automation tool used for data warehouse testing??? Covansys2
what is Governor settings in cagnos?  3
What is power prompts?Can somebody explain me.  2
cognos is holap or molap or rolap Cognizent4
 
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