write a query to display to 10 max record from the employee
table?

Answer Posted / lakhwinder singh

Query for display the top 10 records from the table(tbl1)

select top 10 * from tbl1

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is drill down and slicing and dicing whats the difference between them?

544


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1869


What is the function of model design accelerator?

533


Give me any example of semi and non additive measures?

554


Explain what is the main advantage of impromptu over cognos reportnet?

599






Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

4816


-----------------What is Direct and Conventional loading?

1641


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

600


What are initial page components of Cognos connection?

608


How to generate cubes in cognos?

563


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1644


How the Bursting happens in same report and how to Print the bursting Report?

1441


how to create cubes in transformer ?

618


What is the difference between a data mart and a data warehouse?

541


What are the roles defined by cognos platform?

564