dAivEd Posted October 15, 2009 Report Share Posted October 15, 2009 Krč kas ir baigais tēvs @ php, palidz lūdzu lai nelauzt galvu. Vajag krč vienadus nikus piemēram "JANIS" 3 reizes, "DAVIS", 5 reizes. utt Vajag sarikot topu cik katram ir, piemēram 1. Davis (5) 2. Janis (3) utt... Bet datubāze ir davis davis janis davis davis janis davis janis Quote Link to comment Share on other sites More sharing options...
bubu Posted October 15, 2009 Report Share Posted October 15, 2009 Vienkāršs grupēšanas kverijs: SELECT name, COUNT(*) FROM tabula GROUP BY name Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.