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
Define the cognos reporting tool?
What you mean by drill across?
what do u mean by bridge group? where we r using this one?
Write types of folders present in cognos?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
---------------Describe OLAP Reporting and RDBMS Reporting?
How to Reset Pagenumbers in one report.
What are products of cognos?
What is difference between content store and content manager?
What do you understand by the term 'aggregate advisor?'
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Is it possible to join multiple Databases in a Catalog?
What do you understand by user class in cognos?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is the difference between Open Connection command ang Open Session Command?