Results 1 to 24 of 24

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29

    Select *, max( ÷àñò îò primary key ) from... êàê?

    Ïèøà â php äîëíèÿ ñåëåêò, íî íå ìè âðúùà êàêâîòî î÷àâêàì, à êàòî ãî èçïúëíÿ â phpMyAdmin ðàáîòè êàêòî èñêàì.

    SELECT `egid` , `group_name` , `limit` , MAX( `date` ) FROM employee_groups GROUP BY `egid` ORDER BY `egid` DESC ;

    CREATE TABLE `employee_groups` (
    `egid` int(10) unsigned NOT NULL,
    `date` date NOT NULL,
    `group_name` varchar(50) NOT NULL,
    `limit` smallint(5) unsigned NOT NULL,
    PRIMARY KEY (`egid`,`date`)
    ) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

    Òîâà, êîåòî èñêàì äà èçêàðàì å ñïèñúê íà òàçè òàáëèöà, êàòî àêî çà åäíî è ñúùî egid èìà ïîâå÷å äàòè äà âúðíå ñàìî ðåäà ñ ìàêñèìàëíàòà
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  2. #2
    Ëîø àäìèí! vbTheKing's Avatar
    Join Date: Sep:2003
    Location: Ñîôèÿ
    Posts: 4,138
    Ùîì â phpMyAdmin òè âðúùà òîâà, êîåòî òè òðÿáâà, çíà÷è ãðåøêàòà òè å íÿêúäå â ÐÍÐ êîäà, à íå â ñàìàòà çàÿâêà. Òúðñè ïðîáëåìà òàì. Íå ìîæå åäèí è ñúùè ñåëåêò äà âðúùà ðàçëè÷íè íåùà â çàâèñèìîñò îò òîâà äàëè ñè ãî ïóñíàë ïðåç òâîé ñêðèïò èëè ïðåç phpMyAdmin.
    Ëþáèìî ïèòèå çàïî÷âàùî ñ áóêâàòà 'Ê'? * Êàñà áèðà *
    Àêî ìîæåø äà ëåæèø íà ïîäà áåç äà òè ñå íàëàãà äà ñå äúðæèø - âñå îùå ÍÅ ñè ïèÿí!
    Äàâàéòå ñëåäâàùàòà Êàñà...

  3. #3
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    Íå å â php êîäà ãðåøêàòà. Òîé ñàìî âèçóàëèçèðà result set-a îò çàÿâêàòà.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  4. #4
    Ëîø àäìèí! vbTheKing's Avatar
    Join Date: Sep:2003
    Location: Ñîôèÿ
    Posts: 4,138
    Äîáðå äàé äà âèäèì ÐÍÐ êîäà, ðåçóëòàòà îò çàÿâêàòà ïóñíàòà ïðåç ÐÍÐ è ðåçóëòàòà îò çàÿâêàòà ïóñíàòà ïðåç phpmyadmin.
    Ëþáèìî ïèòèå çàïî÷âàùî ñ áóêâàòà 'Ê'? * Êàñà áèðà *
    Àêî ìîæåø äà ëåæèø íà ïîäà áåç äà òè ñå íàëàãà äà ñå äúðæèø - âñå îùå ÍÅ ñè ïèÿí!
    Äàâàéòå ñëåäâàùàòà Êàñà...

  5. #5
    Áåëûé è ïóøèñòûé Bombera's Avatar
    Join Date: Jul:2001
    Location: Êàçàíëúê 4EVA
    Posts: 13,833
    Êàêâà å ðàçëèêàòà ìåæäó òîâà, êîåòî òè âðúùà èçðàçúò â PHP è òîâà, êîåòî â phpMyAdmin?
    Èëè ïî äðóã íà÷èí äà çàäàì âúïðîñà - êàêâî î÷àêâàø äà òè âúðíå è êàêâî âñúùíîñò òè ñå âðúùà â PHP?(ìàëêî å áåçñìèñëåí, íî ìîæå èäà ñå íàëàãà äà áúäå çàäàäåí òàêà)

    P.S. ×øø, òè íàëè áåøå îôëàéí áðå, vb Àç çàòîâà ñå íàïúíàõ äà íèùÿ
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî

  6. #6
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    ßâíî â stackoverflow ñà ïî-íà òè ñ SQL-à åòî ñåëåêòà êîéòî ðàáîòè:

    SELECT di.*
    FROM (
    SELECT egid, MAX(date) AS date
    FROM employee_groups d
    GROUP BY egid
    ) dd
    JOIN employee_groups di
    ON di.egid = dd.egid AND
    di.date = dd.date
    ORDER BY `egid` DESC;

    À òóê ùå ñëîæà ïîÿñíåíèÿòà çà òîâà êàêâî èñêàõ:

    Òîâà ìè å ñïèñúêà. Êàòî ãî ïðîìåíÿ, äîáàâÿì íîâ ðåä â òàáëèöàòà, ñúñ ñúùîòî egid, íîâà äàòà è íîâè äëúæíîñò è ëèìèòè. Èñêàì â ãîðíèÿ ñïèñúê äà ìè èçëèçàò ñàìî àêòóàëíèòå íåùà, ò.å. ñ ïîñëåäíà äàòà.
    Last edited by kdobrev; 10th May 2010 at 12:09.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  7. #7
    Áåëûé è ïóøèñòûé Bombera's Avatar
    Join Date: Jul:2001
    Location: Êàçàíëúê 4EVA
    Posts: 13,833
    Òîâà ãî ðàçáðàõ, íå ðàçáðàõ â êàêâî å ðàçëèêàòà ìåæäó PHP èçõîäà è òîçè íà phpMyAdmin, çà åäèí è ñúùè èçðàç(áåç çíà÷åíèå, ÷å íå âúðøè òîâà, êîåòî èñêàø).

    P.S. "Ïî-" ñïåöèàëèñòèòå òàì íå òè ëè îáÿñíèõà, ÷å ðåçóëòàòúò îò äâåòå çàÿâêè(òàçè îò ïúðâèÿ ïîñò è òàçè óñëîæíåíàòà) å åäèí è ñúù, ñ ðàçëèêàòà, ÷å ïúðâàòà äàâà åäíà êîëîíà ïîâå÷å, âÿðíî íåíóæíà, íî å íåñðàâíèìî ïî-áúðçà è ïî-íåðåñóðñîåìêà îò äîñòà îïëåòåíèÿ è ñëîæåí äæîéí ñ âëîæåíàòà çàÿâêà?
    È äâàìàòà ñ Âëàäî òå ïèòàìå çà íåùî, êîåòî Å ïðîáëåì, à íå òúðñèì ïîä âîëà òåëå, çàùîòî çàÿâêàòà, êîÿòî ñè äàë â ïúðâèÿ ïîñò, ïðàâè òî÷íî òîâà, êîåòî èñêàø.
    Ìîãà äà ïðèëîæà è ñêðèéíøîò, ÷å ðåçóëòàòèòå íà äâåòå çàÿâêè ñà åäíàêâî èçïîëçâàåìè è èäåíòè÷íè êàòî ðåçóëòàò çà öåëèòå òè.
    Last edited by Bombera; 9th May 2010 at 13:43.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî

  8. #8
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    Code:
     SELECT *
    FROM `employee_groups`
    ORDER BY `employee_groups`.`egid` DESC
    LIMIT 0 , 30


    Code:
    SELECT `egid` , `group_name` , `limit` , MAX( `date` ) as date
    FROM `employee_groups` GROUP BY `egid` ORDER BY `egid` DESC ;


    Code:
    SELECT  di.*
    FROM    ( SELECT   egid, MAX(date) AS date
    FROM     employee_groups d GROUP BY egid
    ) dd JOIN    employee_groups di
    ON      di.egid = dd.egid AND di.date = dd.date 
    ORDER BY `egid` DESC;


    Ïðîìåíèõ çà egid 181 äà å 9999, äîêàòî ïðàâåõ ñíèìêèòå, òàêà ÷å òàçè ðàçëèêà ÿ èãíîðèðàéòå.
    Last edited by kdobrev; 10th May 2010 at 11:49.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  9. #9
    Áåëûé è ïóøèñòûé Bombera's Avatar
    Join Date: Jul:2001
    Location: Êàçàíëúê 4EVA
    Posts: 13,833
    Çàòîâà òè êàçâàìå, äàé äà âèäèì ÏÕÏ-òî, çàùîòî çàÿâêèòå ïðàâÿò åäíî è ñúùî. Ïðîáëåìúò å âåðîÿòíî, çàùîòî ïîëåòàòà ñå äîñòúïâàò ïî èíäåêñè, âìåñòî ñ îáåêò èëè àñîöèàòèâåí ìàñèâ.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî

  10. #10
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    Code:
    while ($row = mysql_fetch_assoc($result1)) {
    	echo "
    	<tr >
    	<td>".$row['group_name']."</td>
    	<td class=\"small_cen\">".$row['limit']."</td>
    	</tr>";
    }
    Åòî ëèíê äî òåìàòà â stackoverflow.
    Last edited by kdobrev; 10th May 2010 at 13:52.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  11. #11
    Áåëûé è ïóøèñòûé Bombera's Avatar
    Join Date: Jul:2001
    Location: Êàçàíëúê 4EVA
    Posts: 13,833
    Ïðè ìåí âñè÷êî ðàáîòè.
    Âñå îùå íå ñå âèæäà ðåäúò ñúñ çàÿâêàòà êúì áàçàòà, äàé âñè÷êîòî.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî

  12. #12
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    Code:
    function display_table_employee_groups() {
    
    	#$sql = "SELECT `egid` , `group_name` , `limit` , MAX( `date` ) as date FROM `employee_groups` GROUP BY `egid` ORDER BY `egid` DESC ;";
    	#/*
    	$sql = "SELECT  di.*
    			FROM    (
    					SELECT   egid, MAX(date) AS date
    					FROM     employee_groups d
    					GROUP BY egid
    					) dd
    			JOIN    employee_groups di
    			ON      di.egid = dd.egid AND 
    					di.date = dd.date 
    					ORDER BY `egid` DESC;";
    	#*/
    	$result1 = mysql_query($sql) or die(mysql_error());
    
    	?>
    	<table><tbody>
    		<tr>
    			<th>Äëúæíîñò
    			</th>
    			<th>Ëèìèò
    			</th>
    			<th>Âàëóòà
    			</th>
    			<th>Ïðîìÿíà
    			</th>
    		</tr>
    <?php
    		$ik = 0;
    		while ($row = mysql_fetch_assoc($result1)) {
    			if ( (($ik++)%2) ) $style = "alt_row_1";
    			else $style = "alt_row_2";
    			echo "<!--<pre>";
    			print_r($row);
    			echo "</pre>-->";
    			echo "
    				<tr class=\"$style\" onMouseover=\"this.className='alt_row_mo'\" onMouseout=\"this.className='$style'\" >
    					<td>".$row['group_name']."</td>
    					<td class=\"small_cen\">".$row['limit']."</td>
    					<td class=\"small_cen\">ëâ.</td>
    					<td class=\"small_cen\">
    						<a href=\"ajax.php?sesid=".session_id()."&action=update&egid=$row[egid]\" rel=\"ibox\" title=\"Ïðîìÿíà íà äëúæíîñò\"><img src=\"images/page_white_edit.png\" class=\"icon_img\" alt=\"Ïðîìåíè\" title=\"Ïðîìåíè\"></a>						
    						</td>
    				</tr>";
    		}
    
    
    echo "</tbody></table>";
    		while ($row = mysql_fetch_assoc($result1)) {
    		echo "<pre>";
    		print_r($row);
    		echo "</pre>";
    	}
    
    	}
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  13. #13
    Áåëûé è ïóøèñòûé Bombera's Avatar
    Join Date: Jul:2001
    Location: Êàçàíëúê 4EVA
    Posts: 13,833
    È òîâà ðàáîòè ïðè ìåí. Äàé äà âèäèì êàêúâ å èçõîäúò îò print_r:
    Òåçè îáëàñòè:
    Code:
    <!--<pre>Array
    (
        [egid] => 183
        [date] => 2010-05-10
        [group_name] => Èçï. äèðåêòîð
        [limit] => 10000
    )
    </pre>-->
    Îòíÿêúäå ãè âàäè òèÿ íóëè, íå å îò íèùîòî.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî

  14. #14
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    Íå ðàçáðàõ êàêâî ïîèñêà, íî òîâà ìè å html-a, êàêòî å ñåãà êîìåíòèðàí print_r-a
    Code:
    	<table><tbody>
    		<tr>
    			<th>Äëúæíîñò
    			</th>
    			<th>Ëèìèò
    			</th>
    			<th>Âàëóòà
    			</th>
    			<th>Ïðîìÿíà
    			</th>
    
    		</tr>
    <!--<pre>Array
    (
        [egid] => 183
        [group_name] => èçï. äèðåêòîð
        [limit] => 0
        [date] => 2010-05-01
    )
    </pre>-->
    				<tr class="alt_row_2" onMouseover="this.className='alt_row_mo'" onMouseout="this.className='alt_row_2'" >
    					<td>èçï. äèðåêòîð</td>
    					<td class="small_cen">0</td>
    					<td class="small_cen">ëâ.</td>
    					<td class="small_cen">
    						<a href="ajax.php?sesid=b39063ea2a84a37fc7f4c6cfc8c4fcd2&action=update&egid=183" rel="ibox" title="Ïðîìÿíà íà äëúæíîñò"><img src="images/page_white_edit.png" class="icon_img" alt="Ïðîìåíè" title="Ïðîìåíè"></a>						
    						</td>
    
    				</tr><!--<pre>Array
    (
        [egid] => 181
        [group_name] => ñúâåò íà äèðåêòîðèòå
        [limit] => 0
        [date] => 2010-05-01
    )
    </pre>-->
    				<tr class="alt_row_1" onMouseover="this.className='alt_row_mo'" onMouseout="this.className='alt_row_1'" >
    					<td>ñúâåò íà äèðåêòîðèòå</td>
    					<td class="small_cen">0</td>
    					<td class="small_cen">ëâ.</td>
    					<td class="small_cen">
    						<a href="ajax.php?sesid=b39063ea2a84a37fc7f4c6cfc8c4fcd2&action=update&egid=181" rel="ibox" title="Ïðîìÿíà íà äëúæíîñò"><img src="images/page_white_edit.png" class="icon_img" alt="Ïðîìåíè" title="Ïðîìåíè"></a>						
    						</td>
    
    				</tr>
    MySQL: 5.0.51a-24+lenny2-log

    PS: Òè êàòî ãëåäàì ïóñêàø "âÿðíî ðàáîòåùèÿ" ñåëåêò, çàùîòî ñà òè ðàçìåñòåíè ïðîìåíëèâèòå â ìàñèâà. Âèæ, ÷å â php-to, êîåòî ñúì ïóñíàë èìà äâà ñåëåêòà è åäèíèÿ å êîìåíòèðàí.  òîâà ïðèìåðíîòî, êîåòî ñúì ïóñíàë å îñòàâåí "âÿðíî ðàáîòåùèÿ"
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  15. #15
    Áåëûé è ïóøèñòûé Bombera's Avatar
    Join Date: Jul:2001
    Location: Êàçàíëúê 4EVA
    Posts: 13,833
    Ïðîáâàõ è ñúñ ñîáñòâåí èçðàç, êàêòî è ñ òâîèòå äâàòà Äàæå è äàííèòå òè êîïèðàõ, çà äà íÿìà ìÿñòî çà ðàçìèíàâêè.
    ßâíî ïðè òåá ïîðàäè íÿêàêâà íàñòðîéêà íà ÏÕÏ ïðåäïîëàãàì, èëè íÿêàêúâ ñúâìåñòèì ðåæèì íà ñúðâúðà, íå òè âðúùà ïðàâèëíî limit, îò çàÿâêàòà. Íÿìàì èäåÿ çàùî îáà÷å.

    5.0.67-community-nt

    ß ïðåèìåíóâàé êîëîíàòà limit, ÷å òîâà å ñëóæåáíà äóìà, äà íå ñå îìàöâà òàì íåùî.
    Ñ åäèí è ñúùè þçúð ëè ñå àâòåíòèöèðàø è ïðåç phpMyAdmin, è ïðåç ñêðèïòà?
    Last edited by Bombera; 10th May 2010 at 15:22.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî

  16. #16
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    ******** ******* mysql

    limit êàòî å â êàâè÷êè íå áè òðÿáâàëî, èíà÷å äàâà ñèíòàêòè÷íà ãðåøêà, à ïîòðåáèòåëèòå ñà ðàçëè÷íè, íî íå ñúì ñè èãðàë ÷àê òîëêîâà ñ ïðàâàòà, èëè îñâåí çà ñúçäàâàíå íà âðåìåííè òàáëèöè äà íÿìà òîÿ, õìì, ùå ïðîáâàì
    Last edited by kdobrev; 10th May 2010 at 15:40.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  17. #17
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Quote Originally Posted by kdobrev View Post
    ******** ******* mysql
    ***** **** àìà íå mysql .
    ßâíî íÿêîé ãî å ïðèìúðçÿëî äà ñå ïîçàïîçíàå ñ îñîáåíîñòèòå íà mysql èëè êîìáèíàöèÿòà ñ PHP. Òîâà âàæè êàêâàòî è áàçà äà ïîäõâàíåø. Ñëåä âèäà íà ïðîáëåìà, êîéòî ñå îáñúæäà òóêà, ñå ÷óäÿ êàê ëè áè ðåàãèðàë àêî ñå çàõâàíåø ñ MS SQL, Îðàêúë èëè äðóãà ïî-ñåðèîçíà .

  18. #18
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    ßâíî íå å îò óñåðà:


    @tedych Íå ìèñëè, ÷å ñå îïèòâàì äà çàêëåéìÿ mysql-a, äîðè ìíîãî ãî õàðåñâàì. Ðàáîòèë ñúì ñ "ïî-ñåðèçíè" è ñúì ðåàãèðàë ïî ñúùèÿ íà÷èí íà òåõíèòå "îñîáåíîñòè" èëè "features"
    Last edited by kdobrev; 10th May 2010 at 16:02.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  19. #19
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    À êàêúâ â êðàéíà ñìåòêà å ïîñëåäíèÿ ïðîáëåì, ÷å íåùî îáúðêàíà ñòàíà òåìàòà?
    PHPmyadmin êàêòî çíàåø å PHP ïðèëîæåíèå, è àêî îñòàíàëèòå ôàêòîðè ñà åëèìèíèðàíè (åäèí è ñúùè óçåð, åäíî è ñúùî PHP è ò.í.) ,íÿêúäå ÿâíî èìàø íÿêîÿ çàáèòà ãðåøêà èëè íÿêîÿ êîÿòî âåðîÿòíî íÿìà íèùî îáùî ñ òîâà, êîåòî ñå îáñúæäà òóê.

  20. #20
    Registered User
    Join Date: Nov:2009
    Location: Ñîôèÿ
    Posts: 29
    Íåçíàì, àêî îòêðèÿ, ùå ãî íàïèøà.
    Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà

  21. #21

  22. #22
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Îùå ïîâå÷å ïîäîáíè íåïúëíè ãðóïèðàíèÿ íå âúðâÿò ïðèìåðíî â SQL Server (2005) .
    È íàèñòèíà îáèêíîâåíî ñå ïðàâè ñ âëîæåí ñåëåêò çà äà íÿìàìå 'ñëó÷àéíè' ñòîéíîñòè çà ïîëåòàòà, çà êîèòî èñêàìå ñòîéíîñòè, îòãîâàðÿùè íà ìà÷íàòèòå îò àãðåãàòíèòå ô-èè ðåäîâå.

  23. #23
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    Ïðîáëåìà å, ÷å mysql çà ïîëåòàòà êîéòî íå ñà â ãðóïàòà âðúùà êàêâîòî ìó ïàäíå. Àêî èñêàø äà èçâàäèø âåðíè ñòîéíîñòè íàïðàâè JOIN îùå âåäíúæ íà òàáëèöàòà ïî ñúîòâåòíèÿ êëþ÷ è îò íåÿ èçâàäè îñòàíàëèòå ñòîéíîñòè îò ðåäà êîéòî òå èíòåðåñóâà. Íå ñúì ãî ïðîáâàë, íî ìîæå è äà ðàáîòè. Àç ïî ïðèíöèï ñè ãî ïðàâÿ ñ îùå åäíà çàÿâêà.

    Code:
    SELECT 
    	eg.`egid` , MAX(eg.`date` ),
    	eg_row.`group_name` , eg_row.`limit` 
    FROM employee_groups eg
    	INNER JOIN employee_groups eg_row ON(eg_row.egid = eg.egid AND eg_row.`date` = eg.`date`)
    GROUP BY eg.`egid`
    ORDER BY eg.`egid` DESC;
    Last edited by _ShadoW_; 14th May 2010 at 10:23.

  24. #24
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    _ShadoW_, îò òàçè çàÿâêà íå âèæäàì îñîáåí ñìèñúë, âúïðåêè ÷å "ðàáîòè" è âðúùà ïðîñòî çàïèñèòå îò òàáëèöàòà.

    Ïðîáëåìúò áåøå êîãàòî èìàìå äâå òàáëèöè è çà äàäåí çàïèñ îò ïúðâàòà òúðñèì ñúîòâåòåí îò âòîðàòà, íî òî÷íî òîçè îò âòîðàòà, çà êîéòî äàäåí field èìà ìàêñ. ñòîéíîñò, è èñêàìå è äðóãè ôèåëäè îò òîçè "âòîðè" ðåä. È äà äæîéíâàø ïî ñúùàòà òàáëèöà, ìàé íå ñòàâà, âñå ñè âðúùà "ñëó÷àéíè" ñòîéíîñòè çà äðóãèòå ïîëåòà. Íå ÷å ñúì ñïåö, íî ñúì ïðîáâàë íåìàëêî êîìáèíàöèè è â êðàéíà ñìåòêà ñ âëîæåí ñåëåêò ñòàâà, âêë. â MS SQL, êúäåòî ïúê íå ïðèåìà íåïúëåí GROUP, à å äîáðå sql-èòå äà ìîãàò ëåñíî äà ðàáîòÿò è â äðóãè dbms.
    Last edited by tedych; 14th May 2010 at 13:12.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè