FTP | CCD | Buscar | Trucos | Trabajo | Foros |
|
Registrarse | FAQ | Miembros | Calendario | Guía de estilo | Temas de Hoy |
|
Herramientas | Buscar en Tema | Desplegado |
|
#1
|
|||
|
|||
Funcion Rows en una subconsulta
Buenos dias,
¿Alguien sabe porque la funcion Rows no se admite en una subconsulta? delete from estudios where id_paciente in (select id_paciente from estudios group by id_paciente having count(estudio) = 1 rows(3)) uso Interbase 7.5. Gracias. Última edición por juanpe fecha: 21-06-2007 a las 10:09:09. |
#2
|
|||
|
|||
Buenos dias, espero que os sirva.
Mi gozo en un pozo. Q. Are ORDER BY and ROWS allowed in subqueries? A. A sub-query, also called a select expression, is a form of table expression. Standard SQL syntax does not specify ORDER BY clauses for any table expression. Standard SQL only allows an ORDER BY with a CURSOR declaration to affect the order in which a result set's rows are returned to the user. For these reasons, InterBase does not allow ORDER BY or ROWS in a subquery. A syntax diagram of what is allowed in a subquery may be found in Chapter 6 of the Embedded SQL Manual with InterBase 6 and 7. Fuente. http://dn.codegear.com/es/article/30296 Asi que ya lo sabemos todos. Un saludo. |
|
|
Temas Similares | ||||
Tema | Autor | Foro | Respuestas | Último mensaje |
SQL statement doesn’t return rows | Jose Manuel | Oracle | 5 | 07-11-2015 00:31:41 |
Multiple Rows in singleton select | IVAND | SQL | 4 | 14-08-2004 21:11:38 |
poner un limite dede rows a una consulta | VRO | Firebird e Interbase | 7 | 07-06-2004 09:46:46 |
Max rows | Eolo | Firebird e Interbase | 5 | 14-02-2004 00:49:01 |
Subconsulta | DanielAlexander | SQL | 3 | 19-05-2003 21:59:56 |
|