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

It is a SQL question. Write a query to find top three
salaries in an EMP TABLE?

Answer Posted / ruchi

In MYSQL:
select salary from (select salary from tbl_salary t order
by salary desc) as u limit 3;

u is the table alias,which is a must.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, is it possible for recording shortcut key during record session? The application on which I am working is web based application. This application has several shortcut key associated with menu option. I have succesfully recorded all menu option but unable to record shortcut key.

1867


How to use parameterization in qtp?

1118


Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?

3496


How will you compare keyword and expert view?

983


When should I use smart identification?

1198


What is the difference in testing a client-server application and a web application?

1168


In Remote acess server how u run a test?

1770


How do Parameterization and Data-Driving relate to each other in QTP?

1113


What are the benefits of qtp?

1290


How many types of run modes are there in qtp?

1072


suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?

1898


What is a data driven test in qtp?

1082


How to interact tool & application build in QTP?

2000


Hi All, I have QTP installed on my machine but the application under test is on remote machine. I need to automate the scenarios which consist of automatically enter the remote machine through IP address ,record the application in remote machine and run it also when played. Can some one tell how to record the application in remote machine.

2095


Explain advantages and disadvantages of ddf?

1123