| |
GeekInterview.com > Tech FAQs > PL/SQL
| Print | |
Question: Querying Customer Details from a Table
Answer: How to query the customer details from a Table who have purchased No. of items greater than 5? |
| August 08, 2008 23:56:05 |
#2 |
| rajivgupta780184 |
Member Since: August 2008 Total Comments: 24 |
RE: Querying Customer Details from a Table
|
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
|
| |
Back To Question | |
