hai chandana your query is very important in realtime iam 
working in infogain in noida  as a testengineer
 with using value statement we can write this query

Hi Sasi

  This is chandana, can u expline me using query r script 
statement ,it is very use ful for me.............

Which data base u r using...based on database the script
will change...

Hi Nanda,

 we r using oracal DB..............so can u write the script
Plz.

hi,
    use this query
  
select * from emp(table name) where rownum<2;

Select column name from table name where row =2 and column 
=3 
i ynk this is the query to test the particular column.

hi,
    use this query
  
select * from emp(table name) where rownum<=2;