Question about Distinct Audio D600 POWER AMPLIFIERS [2-CHANNEL 600W] ( Audio D600) Car Audio Amplifier
CgQuery = "select a.StudentName,d.AdmissionNo,b.ClassName,c.CurrentSection from StuAdmission as a,StuMasterClass as b,StuSectionDetails as c,HostelAdmissionDetails as d,StuClassMapping as e where d.AdmissionNo=a.AdmissionNo and d.ClassID=b.ClassID and e.ClassMappingID=c.ClassMappingID and e.ClassID=d.ClassID and a.CompanyID=d.CompanyID and b.CompanyID=c.CompanyID and d.CompanyID=e.CompanyID and StudentPresentStatus<>'L' "
Sir,In this Query I want to take the distinct (StudentName,AdmissionNo,ClassName)
You probably want a GROUP BY query on the three attributes you specified, and select what kind of aggregation you want (first, last, sum, avg...).
Regards -- Joe
Posted on Feb 07, 2009
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Nov 23, 2016 | Netflix
Register with a website like Track IMEI, Mobile Phones Tracker or Theft Record. You simply have to visit the website and submit your handset's IMEI number. If the company's dealers ever come across a IMEI-number.html#" target=_blank className="iAs" itxtdid="26528975">cell phone with your IMEI number, they will trace it and contact you.
check out Theft Aware - this is a tool that can help you recover your lost or stolen mobile phone. It is completely invisible on your phone and the owner can remotely control his mobile phone and perform a variety of actions that remain invisible to thieves.
I’m happy to assist further over the phone at https://www.6ya.com/expert/joe_8b8c2cd6ce148309
Nov 24, 2010 | Computers & Internet
Oct 01, 2010 | Microsoft Internet Explorer 8
Sep 11, 2010 | Sony KV-35S36 35" TV
Dec 14, 2009 | DKNY NY1304 Watch for Men
Sep 25, 2009 | Nokia N86 Smartphone
Mar 14, 2009 | Computers & Internet
Mar 13, 2009 | HP Computers & Internet
Feb 01, 2009 | Microsoft Windows XP Home Edition
Nov 08, 2019 | Pyle Car Audio & Video
104 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: