Title: select unique / distinct rows using shortcode
Last modified: December 26, 2016

---

# select unique / distinct rows using shortcode

 *  [yositsitsu](https://wordpress.org/support/users/yositsitsu/)
 * (@yositsitsu)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/select-unique-distinct-rows-using-shortcode/)
 * Hi Michael and all,
 * The plugin is super awesome – great job man.
 * I’ve been trying to come up with a solution to make the query results render 
   distinct rows with [cfdb-table] and [cfdb-count] shortcodes, but in vain.. 🙂
 * Can someone give me a pointer of how this can be achieved?
 * I wish I could simply use the distinct sql keyword LOL, but I don’t know how 
   it’s possible with CFDB 🙂
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/select-unique-distinct-rows-using-shortcode/#post-8593886)
 * There is no distinct. You would have to write a [Class Transform](https://cfdbplugin.com/?page_id=1095)
   that weeds out the duplicates.
 *  Thread Starter [yositsitsu](https://wordpress.org/support/users/yositsitsu/)
 * (@yositsitsu)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/select-unique-distinct-rows-using-shortcode/#post-8594263)
 * I see, thanks for the quick response Michael!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘select unique / distinct rows using shortcode’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [yositsitsu](https://wordpress.org/support/users/yositsitsu/)
 * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/select-unique-distinct-rows-using-shortcode/#post-8594263)
 * Status: not resolved