Jump to content


Getting DISTINCT row Results

Grocery crud distinct query model

  • Please log in to reply
3 replies to this topic

#1 nilesht

nilesht

    Newbie

  • Members
  • Pip
  • 7 posts
  • LocationIndia

Posted 07 September 2012 - 05:19 AM

I have to run a simple operation. My table contains records of 24MB (appr 12334000 records). So while loading Grocery crud it not render grid and gives me error.

Now I want to use DISTINCT clause in select query as a solution. That is I want to do query "SELECT DISTINCT(region1) from tbl_country_state_city".

Please, How can I do this so that I get desired results.

Thank you,
Nilesh

#2 victor

victor

    grocery CRUD Hero

  • Advanced Member
  • PipPipPip
  • 967 posts
  • LocationMinsk

Posted 07 September 2012 - 08:29 AM

what kind of error do you get?
I think you have to make your model

#3 victor

victor

    grocery CRUD Hero

  • Advanced Member
  • PipPipPip
  • 967 posts
  • LocationMinsk

Posted 08 September 2012 - 12:07 AM

if you want to reduce the load, you can read http://www.grocerycr...base/#entry2036

#4 bluepicaso

bluepicaso

    Member

  • Members
  • PipPip
  • 21 posts
  • LocationIndia

Posted 12 January 2013 - 02:54 PM

can someone help with a simple model code example.

Harpreet Singh Bhatia
[web developer, programmer, entrepreneur]
Portfolio: TheCodingBox


Follow Me: facebook.png twitter.png googleplus.pngskype.png






Also tagged with one or more of these keywords: Grocery crud, distinct, query, model

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users