SELECT * FROM
(
    SELECT TOP 10 * FROM
    (
        SELECT TOP 30  f1, f2 FROM bench_char 
    ) AS foo
    
) AS bar