knowledgehungry Posted May 15, 2007 Share Posted May 15, 2007 HI ALL, WELL I WANT TO GET THE DATA ABOUT THE EMPLOYEE FROM THE TABLE WHOS SALARY IS THE THIRD HIGHEST SALARY IN WHOLE TABLE . EMP ID IS UNIQUE.TABLE CONSIST OF TWO COULUMNS THTAT IS EMPID AND SALARY Link to comment Share on other sites More sharing options...
Lulzim Posted May 16, 2007 Share Posted May 16, 2007 I don't know the column names of your tables, it should be something like thisSELECT columns_you_want FROM employee INNER JOIN salary ON employee.id=salary.employeeid LIMIT 2,1 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.