select * from emp
minus
(select * from emp where ROWNUM < (select top 1 * from productstate order by productid desc)
There is no TOP keyword in awl server
Type: Posts; User: amisha_me; Keyword(s):
select * from emp
minus
(select * from emp where ROWNUM < (select top 1 * from productstate order by productid desc)
There is no TOP keyword in awl server
in sql server hw we will do this
In sql server hw we will do that