write a query to display to 10 max record from the employee
table?
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 do you understand by the term 'model durability'?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What are the different types of reports present in cognos?
What is cognos connection?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
How to select multiple values from type-in prompt?
What errors and types of errors you faced in Cognos ReportNet?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
7. What is performance tuning?
What is the function of cognos dispatcher?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What is set to be Cognos configuration?
What are all types of Batches?