select class_standard, subject , max(start_dt) from table_name where class_standard ='A' - returns multiple rows
No - it doesn't return ANY rows in an Oracle database.
That query has a syntax error since it includes the MAX function but does NOT have a GROUP BY clause.
Also you have posted in the WRONG forum.
This forum is ONLY for sql developer questions and your question has NOTHING to do with Sql developer.
Please mark the thread ANSWERED.
If you need more help than the above repost your question in the SQL and PL/SQL forum.