Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 6 Answers
- 10243 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ammu
select * from emp e where 4=(select count(sal) from emp
where e.sal>sal)
Because it follows n-1 rule..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are all types of Batches?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is cognos powerhouse?
What is the model filter?
What are the different uses of a repository manager?
write a query to display the departments with no employee?
What are the considerations regarding performance kept in mind while setting up cognos?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What are various types of gateways in cognos?
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.
what is the difference between native sql and cognos sql?
Can you define fan trap?
explain how to create powerplay reports?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
