Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What do you understand by the term 'model durability'?

972


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..

1874


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2251


What are the different types of reports present in cognos?

937


What is cognos connection?

1234


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

2066


How to select multiple values from type-in prompt?

1009


What errors and types of errors you faced in Cognos ReportNet?

4096


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

962


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6801


7. What is performance tuning?

1943


What is the function of cognos dispatcher?

1141


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.

2144


What is set to be Cognos configuration?

974


What are all types of Batches?

979