write a query to display the third record from the employee
table?
- 4 Answers
- 6842 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / srinu
select * from(select rownum r,emp.* from emp) where r=3;
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / kumar
select * from emp where rownum<4 minus select * from emp
where rownum<3;
| Is This Answer Correct ? | 1 Yes | 1 No |
No friends,
rownum is one of the column name of table like
emp_no,emp_name etc. if u have not rownum column in ur
table,how to solve it.
we can retrieve this record through physical location that
is using rowid not rownum.
select min(rowid) from emp not in(select min(rowid) from
emp not in(select min(rowid) from emp));
| Is This Answer Correct ? | 1 Yes | 1 No |
What are the different uses of a repository manager?
difference between drill through and master detail report?
what use of surgate key in project
How do you improve the performance of the Cognos Analytics report
----------------------Diff b/w MOLAP and ROLAP?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
How to create a Left Outer Join in FM? Please explain.
What are the roles defined by cognos platform?
what do u mean by bridge group? where we r using this one?
How can we migrate from Businees Objects reports to Cognos 8.x??
What is Stich Query in Reportnet?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
Teradata 
