Hi,

I am not good at PL/SQL. Anyone can help me to change from SQL to PL/SQL. I am studying in database performance tunning. I have to change from SQL to PL/SQL that will improve performance by doing one time full scan only for LineItem table.

SQL as below:

SELECT COUNT(*)
FROM LINEITEM
WHERE LINEITEM.L_SHIPDATE =
( SELECT MAX(LINEITEM.L_SHIPDATE)
FROM LINEITEM
WHERE LINEITEM.L_SHIPDATE <>
( SELECT MAX(LINEITEM.L_SHIPDATE)
FROM LINEITEM ) );

Anyone pls kindly help me.