Find all the employees who have the maximum credit limit Ple

Find all the employees who have the maximum credit limit. Please use the method 2 (nested select statement). Show your SQL statement and the result.

Query1 L EMPLOYEES EMPLOYEE ID FIRST NAME LAST NAME DEPT CODE HIRE DATE CREDIT LIMIT PHONE NUMBER MANAGER Click to Add 6/1/1998 $30.00 3484 01 Susan Brown Exe Kern Sal 8/16/1999 $25.00 8722 202 Jim 201 shp $25.00 7591 2/2/2009 203 Martha Woods 201 7/1/2008 $15.00 6830 204 Ellen Owens Sa 202 sal 205 Henry 3/1/2006 $25.00 5286 Perkins 202 206 Carol Rose Act Smith shp 12/1/2008 $25.00 2259 203 207 Dan Campbell shp 4/1/2008 $25.00 1752 208 Fred 203 Mkt $15.00 3357 3/17/1999 209 Paula Jacobs 201 Sal Hoffman $25.00 2974 2/16/2007 210 Nancy 203

Solution

select * from L_employees where CREDIT_LIMIT =(select MAX(CREDIT_LIMIT) from L_employees);

The result displayed is the 1st row with employee id 201.