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

What phases are involved in testing an application in qtp?

1020


Dis advantages of XML checkpoint ?

2022


What are the disadvantages of recording test cases in qtp?

1042


How to capture a window in QTP?

1996


I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?

1049


what are the frame work models of qtp?which frame work you follow in your company?and explain it process?

2566


Where you get the run time data table?

1055


What are the automation metrice in your project?

2294


Why is action split used by qtp?

1004


What are the check points can be inserted without recording?

1090


i'm using the qtp to test to vb appliction,i wanted to get the new application's title.i didn't want to use the winAPI to get it ,i 'd like to know whether a QTP function can do it. Eg: SystemUtil.Run "C:\Program Files\.....","","","" 'run an application, and misure the application is activating,then how to get the hwn wihtout using windowns api

2042


What is ‘object spy’ and what is the function of object spy in qtp?

1112


how many maximum number of virtual users we can create?

2160


whare exactly we have to use functions and sub routain

2335


tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?

2196