write a query to display to 10 max record from the employee
table?
Answer Posted / narender.v
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 ? | 2 Yes | 6 No |
Post New Answer View All Answers
Give the advantages of cognos?
how you provide security to reports? How you provide security to packages ?
What is defined as Cognos Impromptu?
whats the difference between previous version of cognos and cognos 8 BI?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
---------------Tell me about DWH Concepts?
What is the difference between Open Connection command ang Open Session Command?
Can you define query studio?
Explain the difference between native sql and cognos sql?
What is cognos powerhouse?
What is the importance of having monitor service in cognos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is the size of the cube?
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.
WHAT ARE THE DISTNICT VARIABLES?