Ocultar campo en el select "Atencion Expertos"
Buenos dias Expertos,
En esta ocasión me dirijo a ustedes para consultar la formula para ocultar un campo (Operación matemática) cuando se realiza el select, por ejemplo:
Tengo la siguiente consulta:
select ID,Fecha, Hora, IF(@INDEZ=0, 0 , ( INDE1 - @INDEZ ) )Salida , (@INDEZ:=INDE1) from cgnatcol01_variables_new join (select @INDEZ:=0)T1 where Fecha='2015-10-24';
La salida es la siguiente:
+------+------------+----------+--------+-----------------+
| ID | Fecha | Hora | Salida | (@INDEZ:=INDE1) |
+------+------------+----------+--------+-----------------+
| 943 | 2015-10-24 | 00:00:00 | 0 | 1888229 |
| 944 | 2015-10-24 | 00:05:00 | 2793 | 1891022 |
| 945 | 2015-10-24 | 00:10:00 | 732 | 1891754 |
| 946 | 2015-10-24 | 00:15:00 | 1059 | 1892813 |
| 947 | 2015-10-24 | 00:20:00 | 2266 | 1895079 |
| 948 | 2015-10-24 | 00:25:00 | 3863 | 1898942 |
Quisiera que la operación matemática "(@INDEZ:=INDE1)" no se imprima.
Espero sus comentarios
Saludos,
Luis Di Nisio
Subject
Views
Written By
Posted
Ocultar campo en el select "Atencion Expertos"
2897
October 30, 2015 06:37AM
1084
November 03, 2015 08:32AM
1104
November 03, 2015 09:32AM
8008
December 18, 2015 05:57AM
828
December 29, 2015 12:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.