by Ritik D Dodhiwala (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 29th April 2005
Date Added: Mon 8th February 2021
Rating: (1 Votes)
You can fetch second higest value from the database
API Declarations
'''with the following query You can fetch second higest value from the database
WHERE (Salary < (SELECT MAX(Salary) AS salary FROM EMPMST))