write a query to display to 10 max record from the employee
table?
- 7 Answers
- 12526 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhoo
You are question is not clear.....you need decide based on
which column you want first 10 records.....
if you work on Salary column this is the query .......
select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/
Any queries on Sql please feel free to ask me i am very
interest in it......
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is difference between data mart and data warehouse?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate ------------- How to identify the Revenue Column in Report?
What do you mean by query studio? in single column there is india and malaysia and uk canada
and dubai,saudi.ok i need using valuable prompt i select
asian country will be display india malaysia and i will
select eurobe country only display uk canada.pls tell me
any how do set this concept using valuable prompt I have two queries in first query i have to show all values,in
second query i have to show 3 values and want to hide 3
values what prompt ur going to use, why that prompt can anybody explain me about sales project in cognos..wt is
the requirement,how u get the requirement..explain me any
one based on ur experience as a report developer..how much
time u will take to complete one project,single person in a
team have to do how many reports..in a real time how much
time will take to complete reports ie..one single report..
(simple and complex report)and in real time ur project
contains how many fact tables and dimension tables..how
many query subjects and query items..wt functional area u
worked on.. hope u vl respond as soon as possible ..my mail-
id is ammu2india@gmail.com ---------------Tell me about DWH Concepts? What you mean by drill across? what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet? hi this is bhaskar iam working in Tcs u want any real time
faqs send me your qs i will ans that qs ok this is my id
bhaskarparitala.rao@gmail.com What are the different types of reports present in cognos? what are the limitations of cognos reportnet? What are the enhancements in reportnet ? How to limit the cut,copy and paste operations for an user
in reportlevel? Can anyone please send me the steps as i am
new to 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
