⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Getting DISTINCT row Results



nilesht

nilesht
  • profile picture
  • Member

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 "[b]SELECT DISTINCT(region1) from tbl_country_state_city[/b]".

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

Thank you,
Nilesh

victor

victor
  • profile picture
  • Member

Posted 07 September 2012 - 08:29 AM

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

victor

victor
  • profile picture
  • Member

Posted 08 September 2012 - 00:07 AM

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

bluepicaso

bluepicaso
  • profile picture
  • Member

Posted 12 January 2013 - 14:54 PM

can someone help with a simple model code example.