binurajnair

 Profile Answers by binurajnair 

• Feb 15th, 2008

 

Please specify the structure of the table(s)

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 11th, 2008

 

select column 1,...column n from table name
where purchaseno<=5;

select rownum,column 1,...column n from table name
where rownum > 5
order by purchaseno;

try this one .....
Thanks
RAJIV GUPTA
YOGIK TECHNOLOGIES PVT LTD.
JAMSHEDPUR

psingla

 Profile Answers by psingla Questions by psingla

• Apr 27th, 2010

 

i guess the table structure would be like

table_name (custname,item_purchased)

so query will be:

select custname from table_name group by custname having count(*)>5