Question about Distinct Audio D600 POWER AMPLIFIERS [2-CHANNEL 600W] ( Audio D600) Car Audio Amplifier

1 Answer

How to use Distinct In AlliesName using Query

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)

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 39 Answers
Re: how to use Distinct In AlliesName using Query

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

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Is there a way to adjust the picture size? On some channels the picture is cropped at the bottom.

this is an aspect ratio problem ans is corrected /adjusted on the on screen menu
use the remote to achieve the on screen menu and scroll around until you find aspect ratio
use the volume buttons to select and adjust

Apr 27, 2015 | Sony 40" FD Trinitron WEGA XBR Hi-Scan TV...

1 Answer

Ok I have an alpine mrv-m500 when I plug the RCA outputs from my head unit they only work if the inputs go across channels ex; left ch(1) right ch(2) or vice versa. When the RCA inputs are correctly...

what type of radio do you have? next in ur radios menu there mighht be a selection of using and amp or not u might to to adjust ur stereo selections for using amp/rca/wattage/loud.fader you get kinda where im going my kenwood and alpine both have this feature in the menu tab..goodluck

May 18, 2014 | Car Amplifiers

1 Answer

My radio whas take of to change my car. Wen i trial to used it the light on the select it is red. I have trial to reset but the select still red and not blue. I am not able to listen cd or radio. The...

not everyone working in the car audio installation is good. not pointing any fingers here. has this problem recently occurred or was it like this since it was installed?

Sep 27, 2013 | Dual XDM-6350 Car Audio Player XDM6350

1 Answer


Your not getting enough power to your amps and this will damage them for sure! You need to have a piece of 4 Ga. wire running from your battery all the way to your amps, also need to have a very good ground very clean and making contact fully through another piece of wire the same size as the + wire from your battery! This is so important that you do this simply because if the wire is too small it will get hot from the current draw by your amps that it will eventually melt the jacket off of the wire and short out or even catch on fire! That sound your hearing is the amps cycling through power up and shutting down since they need 12 Volts of constant voltage and a constant source of current flowing through the wire it will start to power up but once both amps draw from the wire they loose the power needed to stay working, then they do it again, etc... Rewire your amps with large enough wire or if you are using the correct wire then I would suggest checking your battery and then your alternator for problems of under voltage. Hope this helps, always make sure to place a fuse in line from you battery + terminal no further than 18" from the connection to you battery and use a fuse that is rated for the WIRE being used. Your trying to keep the wire from burning up that's all that the fuse is for. The fuses on the amps are to keep your amps from burning up they are not protecting that wire at all.

Aug 20, 2013 | Jensen XA2100 Car Audio Amplifier

1 Answer

I have a kenwood 350watt amp on 2 mtx thunder 12's

Check the impedence of the connected speakers. if any impedence mismatch is there, the amp will sense it and will cuto the output OFF. Use only specified speakers only. The impedence of speakres are expressed in "Ohms". Select all speakers of same impedence. If 6 Ohms is the output impedence of the amp, use only that Ohms speaker. Never use a speaker less that this Ohms. You can use a higher impedence speaker, say 8 Ohs or 16Ohms. But never use lower impedence speakers, of connect two speakers in parellel connection, which will relult in overloading. I think that I've made a satisfactory solution to you. Please don't hesitate to rate this solution. Good luck
Wish you a Merry X'mas and Happy 2012.

Dec 21, 2011 | Kenwood Car Amplifiers

1 Answer

The amp goes in and out of protected mode

could be the sub wired incorrectly to the amp.i have had same problem and used same fix. everything has been workin fine ever since. check out this link an select the correct option for your set up an it will show you the sub to amp wiring

Mar 03, 2010 | JBL GTO 1201.1II Subwoofer Mono Amp - 800W...

1 Answer

What speakers

Hello enot99,

The CC-2502 is a bridgeable 2-channel amp. If you want to drive normal speakers in stereo, the best would be a good set of components with separate woofers, tweeters, and crossovers. They are available in many sizes from most car audio manufacturers. I'd begin by finding out what speakers fit the location where you intend to mount them. Then I'd browse the speaker selections in that size at You can also use the "outfit my car" feature to browse only the products that fit. Then select a pair that has a power range and impedance to match the amp: 250 watts RMS at 4ohms or 450 watts RMS at 2ohms.

If you want to use the amp in bridged mono mode to drive a subwoofer, again Crutchfield has a large selection of subs and some enclosures already fitted with subs (loaded). The amp claims 850 watts RMS into 4ohms bridged, so look for a sub that has a power handling rating of at least 850 watts and it needs to be 4ohms.

Hope this helps.

Aug 02, 2009 | Concept CC-2502 Car Audio Amplifier

1 Answer

Setting clock

Press and hold the select (SEL) button.
select the "Clock H" (clock hour) or "Clock M" by using the buttons (|<< or >>|)
Finsih procedure by pressing the select (SEL) button.

May 08, 2009 | JVC Car Amplifiers

2 Answers

No power seaworthy marine amp 400

Do you have anything plugged into the "REM +" slot on the power side of the amp? You need either a signal from a Stereo head unit or another power source to get the amp to actually turn on. If you are using a switched setup for the amp, you can make a little jumper from the Batt+ to the REM+. It doesn;t draw anything significant, it just needs power to signal the amp to turn on. If you aren;t using a headunit, make sure that you wire in a switch inline between ther power source and the REM+ port on the amp, otherwise, the amp will be on all the time.

Mar 30, 2009 | Sea Worthy SEA / AMP 400 Car Audio...

2 Answers

Alpine 3523 no instructions or wiring

I know this is a little late but I have one and the hookup is very easy, On the right side of the amp there is a six pin plug. Above it it says BATT REMOTE GND. The two pins below BATT are the battery (V+). The pin below REMOTE is the (V+) switched turn on. The two pins below GND are the ground. The rest is simple. Two RCA inputs. The switch to select MONO(R), STEREO, or MONO(L) works as explained. If you want stereo, put the switch in the middle and supply two inputs and two speakers. The MONO(R) and MONO(L) are to select a single input that will supply a single (bridged) output. Connect two speakers and they will supply the same source or connect one speaker to the outer speaker terminals for higher power output. The variable or fixed switch just bypasses the GAIN CONTROL knobs(used for Alpine's 8 pin DIN plug on unit, for older EQ's and head units.

Jan 15, 2008 | Car Amplifiers

Not finding what you are looking for?
Distinct Audio D600 POWER AMPLIFIERS [2-CHANNEL 600W] ( Audio D600) Car Audio Amplifier Logo

Related Topics:

86 people viewed this question

Ask a Question

Usually answered in minutes!

Top Distinct Car Amplifiers Experts

Tygh Duval
Tygh Duval

Level 2 Expert

290 Answers

Pablo Gonzalez

Level 3 Expert

733 Answers

Donald DCruz
Donald DCruz

Level 3 Expert

17129 Answers

Are you a Distinct Car Amplifier Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides