Provides various official and user-released code examples. For code reference, you are welcome to exchange and learn how to write this SQL statement using the M syntax.
Please let me know. QQ29295842
// Pagination
Import ('org. Util. page'); // import
$ Count = M ('Open _ ip')-> count (); // obtain the total number of items
$ Page = new Page ($ count, 10); // instantiate the number of entries per page
$ Limit = $ page-> firstRow. ','. $ page-> listRows; // read the number from the nth to the nth
$ Wish = M ('Open _ ip')-> order ('time desc')-> limit ($ limit)-> select ();
$ This-> wish = $ wish;
$ This-> page = $ page-> show (); // page number
Select url1, count (url1) from tk_open_ip group by url1 having count (url1)> = 1 order by count (url1) desc
How can I execute this statement?
Under TP
AD: truly free, domain name + VM + enterprise mailbox = 0 RMB