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

An employee table, with the columns id, name, sal and
dob.Query to select emp names of all highest salaries(there
are 4-5 people having the same salary which happens to be
the highest).

Answer Posted / naveen kamatam

select ename, salary from emp e
where 4 > (select count(distinct salary)from emp where
Salary > e.salary)

it will fetch top 4 high salary records

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is smoke testing and what is sanity?

1213


how to connect your project in database?

2069


hi what are the test cases for web application..i need these example..please..mail me at mina_ims@yahoo.com

2025


Explain the strategy for testing a Java application?

2168


whta is compile module?

2171


What is white box testing, and what are the various techniques?

1142


What is middle ware testing?? what are the companies using this tech?

2320


How to explain a banking project in interview ? like project discription is Client Online Banking Application provides access to information relating to Banking Online Services provided by Axis to View daily customer transactions, Current and Previous customer statements, Transfer funds from Chequing and Savings accounts ................ From interview point of view can any one explain this project in laymans language

10670


What is the difference between load testing and performace testing?

1208


What is your approach when requirements change continuously?

1200


Plz give me manual testing real test case ?

1578


i want to for technical interview question paper along with in tesrviwe Phases i need

1966


Hi I am searching job please send some details abuot ERP project and real time test plan,traceability report,test case if any relate to erp project Please help me out to get a job in testing.my email address is chiku_69@yahoo.in Thank u

2815


What is bug, deffect, issue, error?

1333


What is the Difference between Network testing and Web Testing?

2296