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 the third record from the employee
table?

Answer Posted / j

select * from emp e where 3=(select count(sal) from emp
where e.sal>sal)

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1072


------------ Diff b/w MemberCaption and MemberDescription?

2365


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4284


what is the difference between native sql and cognos sql?

1049


How is possible this scenario using in type-in prompt.?

1101


how to explain health care project and which reports we can create in health care doain?

6846


What do you understand by the term 'aggregate cache'?

1023


How to create model and how to test model?

1073


What is a Framework manager?

1078


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2048


what is online view?

1988


What is the advantage of using shortcuts?

1247


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2143


Can you define a catalog and types of catalogs in cognos?

1095


What is looping and how to avoid it in framework manager?

1252