Re: how to generate the following output in sql ?

Helllo Supratim, does each pub_code appear maximum three times in the table? 2008/11/10, Supratim Bandyopadhyaya <[EMAIL PROTECTED]>: > > I am really really new to sql,please forgive my > ignorence. > > here is my problem > > I have this table named mis_outtrack > > desc mis_outtrack; > +

how to generate the following output in sql ?

I am really really new to sql,please forgive my ignorence. here is my problem I have this table named mis_outtrack desc mis_outtrack; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+