Em Andamento

SQL questions

Doing some PL/SQL and would like to optimize the code. So the main thing is speed and simplicity. I have some specific questions below: Question 1: Summarizing the column X from the table below into another table with the same fields. Table 1: M X A ---------- 1 1 a1 2 2 a2 3 1 a3 2 1 a2 4 3 a4 4 1 a4 Giving Table 2: M X A ---------- 1 1 a1 2 3 a2 3 1 a3 4 4 a4 Question 2: Subtracting X from Table 2 from column XX in Table 3. Table 3: (before) M XX A 0 45 a1 1 23 a2 2 1 a3 3 10 a4 4 2 a5 5 23 a6 Table 3: (after) M XX A 0 45 a1 1 22 a2 2 -2 a3 3 9 a4 4 -2 a5 5 23 a6

## Deliverables

1) Tested examples

## Platform

Oracle 7.x, 8.x, 9.x

Habilidades: Administração de Bancos de Dados, Engenharia, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: would questions, sql to oracle, sql oracle pl sql, sql in pl sql, sql code oracle, pl sql in oracle, pl sql examples oracle, pl sql and oracle, pl sql and, oracle sql pl, oracle pl sql code examples, code pl sql, pl sql oracle, oracle sql with, in pl sql, a6, SQL PL SQL , sql and c, pl\sql, pl/sql, pl-sql, oracle:pl, oracle pl/sql, oracle pl, optimize php code

Acerca do Empregador:
( 1 comentário ) Denmark

ID do Projeto: #3018126

Premiar a:

tzunivw

See private message.

$5 USD em 2 dias
(26 Avaliações)
2.9

4 freelancers are bidding on average $38 for this job

ekam

See private message.

$21.25 USD in 2 dias
(111 Comentários)
5.7
shashikhanvw

See private message.

$85 USD in 2 dias
(15 Comentários)
3.8
sandeepjvw

See private message.

$42.5 USD in 2 dias
(3 Comentários)
3.6