сложение 1 и 4 записи, 3 запись. вот так получается.
грубо говоря, мы игнорируем все записили при повторе id_j. из-за этого везде, где в записях есть 2 в id_j игнорируются. и остаются три записи, которые суммируем
SELECT A.ID_H,
SUM(A.COST) COST
FROM (SELECT ID_H,
ID_J,
COST,
RANK() OVER(PARTITION BY ID_J ORDER BY ID_H ASC) RNK
FROM MYTABLE
) A WHERE A.RNK = 1
GROUP BY A.ID_H
SELECT r.id,
c.relation_cpu_id cpu_hash,
LISTAGG(m.relation_monitor_id, ', ') WITHIN GROUP (ORDER BY m.id) AS monitor_hash
FROM report r
LEFT JOIN v_cpu_relation c ON r.id = c.relation_report_id
LEFT JOIN v_monitor_relation m ON r.id = m.relation_report_id
GROUP BY r.id,
c.relation_cpu_id
select l.prod, l.id list_id, l.list_val from list l left join main m on <Дальше сам>
SELECT * FROM `objects`
WHERE `bid_type`='$bid_type'
AND `object_type`='$object_type'
AND (`address` LIKE '%$address%'
OR `okrug` LIKE '%$address%')
begin
insert into ..... returning id into :id;
-- ...
commit;
end;
SELECT a.name
sum(a.zarp)
FROM (SELECT name,
IFNULL(zarp, 0) zarp
FROM PRIC
union all
SELECT name,
IFNULL(amount, 0) zarp
FROM AMO
) A
GROUP BY a.name
BEGIN
UPDATE kolesa_brands SET name = 'name' WHERE id = <id>;
IF SQL%NOTFOUND THEN
INSERT INTO kolesa_brands (id, name) VALUES (<id>, '<name>');
END IF;
END;
<id>, <name>
нужно подставить значения $opt->value и $opt->plaintext). Так как для merge нужно две таблицы можно попробовать использовать виртуальную таблицу dualmerge into kolesa_brands t
using ( select <id> id, '<name>' name from dual ) n on ( t.id = n.id)
when matched then
update set t.name = n.name
when not matched then
insert (t.id, t.name) values (n.id, n.name)
<blockquote>require_once "simple_html_dom.php";
error_reporting(E_ALL);
ini_set('display_errors', '1');
$conn = oci_connect('ddd', 'ddd', '127.0.0.1/orcl', 'AL32UTF8');
$brands = array();
$html = str_get_html(file_get_contents('https://kolesa.kz/cars/'));
$i = 'begin ';
$i .= '\r\n';
$select = $html->find('select[id=auto-car-mm-0]', 0);
foreach($select->find('option') as $opt)
{
if($opt->value == '') continue;
$i .= 'merge into kolesa_brands t ';
$i .= 'using (select '.$opt->value.' id, \''.$opt->plaintext.'\' name from dual) n on (t.id = n.id) ';
$i .= 'when matched then ';
$i .= 'update set t.name = n.name ';
$i .= 'when not matched then ';
$i .= 'insert (t.id, t.name) values (n.id, n.name);';
$i .= '\r\n';
$brands[$opt->value] = $opt->plaintext;
}
$i .= '\r\n';
$i .= 'end;';
$insert = oci_parse($conn, $i);
oci_execute($insert);</blockquote>
SELECT I.NAME_INSTITUTION,
A.UID_FIELD,
A.ANSWER_USER,
COUNT (*) CNT_ANSWER
FROM LIST_INSTITUTIONS I
LEFT JOIN LIST_ANSWERS A ON A.UID_INSTITUTION = I.ID_INSTITUTION
GROUP BY I.NAME_INSTITUTION, A.UID_FIELD, A.ANSWER_USER
HAVING COUNT (*) > 1
$dbres = mysql_query("
SELECT *
FROM SC_local
WHERE
(id='credit_mail_title' OR id='email_hello')
");
$credit_fetch_lan=mysql_fetch_row($dbres);
print_r($credit_fetch_lan);
Private Sub CommandButton1_Click()
'Строка подключения
cConn = "Driver={Oracle in OraClient11g_home1};Dbq=<SID>;Uid=<User>;Pwd=<Password>;"
Dim Cn As ADODB.Connection
Dim Cm As ADODB.Command
Set Cn = New ADODB.Connection
Cn.Open cConn
Set Cm = New ADODB.Command
Cm.ActiveConnection = Cn
Cm.CommandText = " begin MyStorageProc('" + Range("A1") + "') end;"
Cm.CommandType = adCmdText
Cm.Execute
End Sub
SELECT I.Id,
C.CBilling_date,
C.Name,
C2.Name -- Имя клиента, на которого ссылается клиент текущего счета
FROM Invoices I
left join Customers C ON C.Id = I.Customer_ID
left join Customers C2 ON C2.Id = C.Referred_ID
GROUP BY I.Billing_date