Select name_a, 
         count(*), 
         min(nomer) as min_n, 
         max(nomer) as max_n
         From table_1
         Where dat_start >= '2008-01-01'  and dat_end <= '2008-02-01' 
         Group by name_a

IsNull(name_a,' ')

SELECT seria_pl,
         count(*),min(nomer_pl) as '№ beg', max(nomer_pl) as '№ end'  
    FROM put_list  
   WHERE dbo.put_list.dat_close between :dat_beg and :dat_end   
    group by seria_pl

 SELECT "" as seria_pl,
         count(*),min(nomer_pl) as '№ beg', max(nomer_pl) as '№ end'  
    FROM put_list  
   WHERE dbo.put_list.dat_close between :dat_beg and :dat_end 
    and (dbo.put_list.seria_pl is null or dbo.put_list.seria_pl ="" )
UNION 
  SELECT seria_pl,
         count(*),min(nomer_pl) as '№ beg', max(nomer_pl) as '№ end'  
    FROM put_list  
   WHERE dbo.put_list.dat_close between :dat_beg and :dat_end   
    and (dbo.put_list.seria_pl is not null and dbo.put_list.seria_pl <>"" )
    group by seria_pl
    order by seria_pl

select
case when seria_pl is null or seria_pl ='' then 'a' end as seria_pl,   
count(*), min(nomer_pl), max(nomer_pl) 
from put_list 
where dat_close between '2008-08-26' and '2008-09-18'
group by seria_pl

begin
select
case when seria_pl is null or seria_pl ='' then 'a' else seria_pl end as seria_pl,   
nomer_pl
into tt
from put_list 
where dat_close between '2008-08-26' and '2008-09-18'

select seria_pl, count(*) as cn, min(nomer_pl) as min_n, max(nomer_pl) as max_n from tt
group by seria_pl

drop table tt
end

dw_1.SetTransObject(sqlca)
dw_1.retrieve( Date(w_osn.uo_1.sle_date.text),Date(w_osn.uo_2.sle_date.text) )

select isnull(seria_pl, ''), count(*) 
..... 
group by seria_pl

select '' as seria_pl,
count(*) 
..... 
where (seria_pl is null or seria_pl = '')

union

select seria_pl, count(*) 
..... 
where (seria_pl is not null and seria_pl <> '')
group by seria_pl

select 
isnull(seria_pl, '') as 'seria_pl', 
nomer_pl
into temp_table
from put_list
where dat_close between :dat_beg and :dat_end

select seria_pl, 
count(*) as 'cn',
min(nomer_pl) as 'min_n',
max(nomer_pl) as 'max_n'
from temp_table
group by seria_pl

drop table temp_table

SELECT sum(T.A),
           T.B
FROM
(select  1  as a,
           2  as b
union 
select  3  as a,
          2  as b
) T
GROUP BY T.B

select seria_pl, count(*), min(nomer_pl) as '№ beg', max(nomer_pl) as '№ end'
from (
select 
isnull(seria_pl, '') as 'seria_pl',
nomer_pl
from put_list
where dat_close between :dat_beg and :dat_end )
group by seria_pl
order by seria_pl