2 SQL's in Single statment & write NULL values in the record set also to Excel sheet

[prasadsbrk]

Hi,

How to execute 2 SQL statments in single resultset & i need to write the RS values to excel including NULL's
like
set rowcount 10;
select * from emp where deptno = 10 order by empno;

such that i need top 10 records only.

Thanks in advance ....

[Saket]

use top(n) in your SQL statement

select top(10) from emp where deptno = 10 order by empno;

[Tarik Sheth]

You can use row number <11 in the where condition.