gorup by query issue
i have one table,
which has three fields and data.
Name , Top , total
cat , 1 ,10
dog , 2, 7
cat , 3 ,20
hourse 4, 4
cat, 5,10
Dog 6 9
i want to select record which has highest value of "total" for each Name
so my result should be like this.
Name , Top , total
cat , 3 , 20
hourse , 4 , 4…
I have one table, which has three fields and data.
Name , Top , Total
cat , 1 , 10
dog , 2 , 7
cat , 3 , 20
horse , 4 , 4
cat , 5 , 10
dog , 6 , 9
I want to select the record which has highest value of Total for each Name, so my result should be like this:
Name , Top , Total
cat , 3 , 20…
I'm trying to make a blogging system but obviously certain users in certain groups should only be able to edit/delete their own posts/comments. How would I go about doing this in CakePHP? I followed the manual's basic Acl guide to setup my current Auth system.
How I can create a crystal report in php kindly guide me so that I can make it possible. I have tried a lot of code and tutorials but un-usefull for me.
Hi friends,
i know it would sound too ambitious but our client requires a PDF Reader of his own with some selected functionalities. Can any1 here guide me to some good tutorials for paving the way to start its development?
i guess i need to clear some pdf basics and start from scratch OR i would be happy if there is any api which i can use…
How do I get my .NET Winforms app 2.0 to automatically update it's publish revision integer subsequent to issuing the publish command from within VS08.
Trying to use the following C# as a guide
object[] attrs =
System.Reflection.Assembly.GetEntryAssembly().GetCustomAttributes(true);
foreach (object o in attrs)
…
I have done a course in Data warehousing and Mining and i am interested in going the Cognos BI way. However, i need to practice on data which i cannot find. Can someone please guide me on getting myself aquainted better with cognos ? I need sample data to work on. Where do i find it ?
Hey guys,
i have some difficulties to understand this scénario ...
i create an object
i set its retained property to something
i Forget to release its property
i release the object
as i didn't release the property in the dealloc
method, Will the scénario result in a memory leak or Will the property be released automatically ?
And yes,…
Hi, I've been using XPath with Selenium quite happily and even using getEval with a but of Javascript, but a colleague said wouldn't it be great to be able to use JQuery selectors in Selenium.
I've googled it, but can't find any articles that seem to work for me. Could anyone provide a comprehensive guide on how to use JQuery syntax to…
Since Silverlight 4 Microsoft recommends the usage WCF RIA services for business applications. Are there scenarios, where the WCF RIA serices should no be used and plan WCF services or webservices or other techniques are the better choice ?
hi friends..
I have a plan of creating Dynamic UI in iphone using webservices ..that is the UI will be build according to the xml content from a webservice.
I need to know some of your suggestions regarding this... where will i get resources for building such an app... are there any tutorials available.....?
Hi,
I want to learn C , UNIX and LINUX, and more about embedded systems. Very much interested in them. Are there any online courses or websites which can guide me. And please suggest books to read in learning them.
Thanks for your time.
Hi,
I'm learning Ruby, and I'm starting to play with building extensions in C. I have Programming Ruby The Pragmatic Programmers' Guide and so I can follow that for the basic nuts and bolts. What I was wondering is if there already existed some nifty frameworks/whatever to help interoperability between Ruby and other languages, with…
I am a developer a large social network.
Does the protocol OAuth without browser? I plan to write desktop and mobile applications that can not use your browser to get access_token. It worries me step for get Access_token, I can not understand how to implement it.
Give examples of code if possible ...
Hi iPhone experts,
I am a registered Apple developer. I am developing an iPhone application for my client. If i want to give my app build to my client for testing my build, do i need to create a build using my adhoc provisioning profile and send the build as well as my adhoc provisioning profile to my client? If yes, how can they…
Hi,
We plan to advertise our iphone app on other sites. Is there a way to track from which website my iphone app hyperlink was clicked when a purchase is made? Can this be programmed, or is there any analytics app which does this. We will want to track the exact number of sales made from each site..
Appreciate any help..
mb
Hi,
I plan to work with android . Please point me some good books and blogs/discussion/tutorials/ forums for getting vast and in depth knowledge quickly about this android technology.
I already know the basics of RegEx but I'm not sure where to go from here, I'm looking for both a good and above all easy to understand guide but I am also looking for things to use RegEx's for, it's all well and good reading about it but if you never use them then they will not stick in your mind.
I have already found…
As per this link code from stack overflow i have try this code for getting
friendslist but after login i got this error "requires valid signature"
string APIKey = ConfigurationManager.AppSettings["API_Key"];
string APISecret = ConfigurationManager.AppSettings["API_Secret"];
Facebook.Session.ConnectSession…
I am currently learning asp.net MVC2. I was trying to do a simple project similar to tadalist.com
Could you please guide me to some articles on how to create the dynamic textboxes and how to capture the user input for persistance?
Thanks
I am trying to integrate DOJO to my existing struts application.
Listed below are the steps I followed.
1.Downloaded DOJO 1.4, copied dijit,dojo and dojox folders under my application folder jsp-jsDOJO
copy paste "dialog via mark up example"…
I've created an animation using script.aculo.us. However, when the animation is finished, I want to have it reset all the objects and perform the animation again. I plan to just reset the positions of the objects manually, but how can I make the…