Hello,
In the following query, an error is encountered in the execution:
select
fto.id_taxon,
fto.cd_sexo as fto_cd_sexo,
fto.cd_idade as fto_idade,
x.ftv_cd_sexo,
x.ftv_cd_idade,
x.id_fv
from
tb_foto_oco...
I was able to assemble the result, but now I want to create the view with this result. What is the best way?
This query:
"SELECT CONCAT(CONCAT(CONCAT('SELECT * FROM ',a.OWNER),'.TAB2'),CASE WHEN a.OWNER = UPPER(b.TESTE1) THEN '' ELSE ' UNIO...
I have the table maintenance with the column product_id (varchar (MAX)) , but it is not the primary key, the table has 900 thousand records so I decided to create indexes to optimize searches.
I've done the following tests:
create index...
Good morning, I'm new here and I have a boring problem. Distinct does not solve my problem because the duplication is due to the fact that I had to make the relationship with other tables to look for information. I have a SQL statement that I wa...
I basically learned SQL with PostgreSQL, I am first making use of SQL Server and could not figure out how to do this in it.
Let's say I have two tables. The first is a generic transaction table (sales, rentals, bookings, etc.)
CREATETABLE[db...
I have in my form the option to perform a search for Rg or Cpf. Then I came to doubt about query performance using the following code:
SELECT * FROM DADOSPESSOAIS WHERE (Rg = @Rg OR Cpf = @Cpf);
This code above "costs" more than if I made t...
I developed a page in PHP for internal use of the company I work with and only very few people use it. You can use this page to do some queries, insertions, changes and deletions of a table in a MySQL database, however I believe that my PHP code...
I need to remove data from a database file (.db) file that I was told is SYBASE, the client needs to migrate data and need access, does anyone have a clue where to start? because you never hear of sybase.
Remembering that it is not a server,...
The question is as follows, in mysql we can concatenate a query and then perform the search, as follows:
$cidades = '&& (cidade = 100 || cidade = 101 || cidade = 102)';
$order = 'id ASC';
$sql = 'SELECT * FROM tabela WHERE status = 1...
Hey guys, I need help, I'm a beginner in java, and I'm doing a college job where it's going to be a mini social network, in the beginning let's do user registration, inside the beans class, user receives a Friend List I'm com a doubt.
My ques...