| Sign In/My Account | View Cart |
Article:  |
SQL Subqueries | |
| Subject: | i want a previous value of the max value | |
| Date: | 2005-10-27 23:35:55 | |
| From: | jagadishprem | |
|
Response to: i want a previous value of the max value
|
||
| SELECT MAX(SAL) FROM EMP WHERE SAL<(SELECT MAX(SAL) FROM EMP) | ||
| Privacy Policy > View Sample Newsletter > |
800-889-8969 or 707-827-7019 Monday-Friday 7:30am-5pm PT ©2011, O'Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
|