9 Replies Latest reply: Mar 28, 2013 8:01 AM by jeneesh RSS

    please help me to build the query

    user9077483
      I have a country table it is having 50000 records.
      my requirement is
      If I pass the country name query has to fetch details corresponding to that country.
      Example if I pass the country name as INDIA query has to fetch all the records corresponding to INDIA.
      If I pass country name as ALL query has to fetch the details for all the countries.i.e 50000 records.

      I have written the following query ,but it is working for particular country it is not working for ALL.

      If I pass parameter as ALL query has to fetch all the records.
      SELECT * FROM country_names
      WHERE country=&country
      Please help me.

      Thanks.