Ygthkb

What does an unprocessed RAW file look like?

Does diversity provide anything that meritocracy does not?

Remove isolated elements of a vector

Case protection with emphasis in biblatex

Is there a way to pause a running process on Linux systems and resume later?

Count repetitions of an array

Is it possible to rotate the Isolines on a Surface Using `MeshFunction`?

Does the US government have any planning in place to ensure there's no shortages of food, fuel, steel and other commodities?

Should a new user just default to LinearModelFit (vs Fit)

How to change a .eps figure to standalone class?

Concatenating two int[]

Single-row INSERT...SELECT much slower than separate SELECT

Sitecore 9.1 Installation - Skip to particular step

What can I do to encourage my players to use their consumables?

How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?

Caron Accent v{a} doesn't render without usepackage{xeCJK}

Icon at Subject-line scrlttr2

How to not let the Identify spell spoil everything?

Why did Luke use his left hand to shoot?

To be or not to be - Optional arguments inside definition of macro

Plausible reason for gold-digging ant

How long has this character been impersonating a Starfleet Officer?

How much light is too much?

Reading Mishnayos without understanding

Alias from outer query not recognized

Identical subquery optimisation in an updateSelect query for returning different data based on creation timehow to solve slow running sub query TSQLHow to subtract records from a table based on their existence in anotherProblem forming a query with subqueries in design view? (MS Access 2010)?Join subquery by year and monthHow to limit an inner query by outer query attributeReuse results from correlated subqueries in same queryMySQL unknown column in subqueryUse an array returned from a subquery as argument in WHERE clause with ANY function in outer query

0

create or replace view test as select nombre, to_char(to_timestamp((select extract(month from fecha_inicio))::text,'MM'),'Month') as mes,(select extract(year from fecha_inicio)) as anno,

sum(monto)+(select sum(monto) from otros_ingresos where (select extract(year from fecha))=anno and (select extract(month from fecha))=mes) from ganancia_por_cierre

group by mes,anno,nombre;

ERROR: no existe la columna «anno»

subquery

share

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1

New contributor

Enrique Pérez Batista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

create or replace view test as select nombre, to_char(to_timestamp((select extract(month from fecha_inicio))::text,'MM'),'Month') as mes,(select extract(year from fecha_inicio)) as anno,

sum(monto)+(select sum(monto) from otros_ingresos where (select extract(year from fecha))=anno and (select extract(month from fecha))=mes) from ganancia_por_cierre

group by mes,anno,nombre;

ERROR: no existe la columna «anno»

subquery

share

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1

New contributor

Enrique Pérez Batista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

create or replace view test as select nombre, to_char(to_timestamp((select extract(month from fecha_inicio))::text,'MM'),'Month') as mes,(select extract(year from fecha_inicio)) as anno,

sum(monto)+(select sum(monto) from otros_ingresos where (select extract(year from fecha))=anno and (select extract(month from fecha))=mes) from ganancia_por_cierre

group by mes,anno,nombre;

ERROR: no existe la columna «anno»

subquery

share

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1

New contributor

Enrique Pérez Batista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

create or replace view test as select nombre, to_char(to_timestamp((select extract(month from fecha_inicio))::text,'MM'),'Month') as mes,(select extract(year from fecha_inicio)) as anno,

sum(monto)+(select sum(monto) from otros_ingresos where (select extract(year from fecha))=anno and (select extract(month from fecha))=mes) from ganancia_por_cierre

group by mes,anno,nombre;

share

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1

New contributor

Enrique Pérez Batista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1

New contributor

Enrique Pérez Batista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1

New contributor

Enrique Pérez Batista is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Enrique Pérez BatistaEnrique Pérez Batista

1