Best answeres tagged with sql

2

answers

How to make a Select not to display zeroed result?

I have the select below, which always brings me two lines, one with zero and one with value: SELECT COUNT(DISTINCT ROMANEIO) ROMANEIO FROM PCN_ROMANEIO_DISTR_ITEM WHERE USUARIO = 'junior' UNION ALL SELECT COUNT(DISTINCT ROMANEIO) ROMANEIO FROM...

asked by 26.10.2016 / 15:38

2

answers

Question about delphi 7 query

I'm having a problem trying to run an update query in my database, delphi gives an error as an incorrect syntax, but I could not find the problem. Could someone help me please? Follow prints:

asked by 23.05.2016 / 20:38

4

answers

How to create a Boolean column in Oracle?

As far as I know, Oracle does not provide Boolean valueType . I am working briefly with Oracle and would like to know the best solution to "simulate" a true / false value in the Oracle database? CHAR(1) (Y/N) ? INTEGER (0/1) ?

asked by 29.02.2016 / 14:11

2

answers

Which SQL server command to list the user's transaction isolation level

Is there any command I can run on the sql server to list the user's transaction isolation level?

asked by 05.09.2014 / 19:28

2

answers

Group table data with two columns

Well, I'm in an incognita I'd like to solve directly in the SQL query, see this supposed example: TIPO | DE | IDENTIFICADOR ------------------------- 001 | 23 | 9 001 | 44 | 9 001 | 23 | 8 002 | 11 | 11 I want to group the data in ord...

asked by 15.11.2016 / 22:00

2

answers

Help with mysql curdate () - 1

I'm getting this error: # 1064 - You have an error in your SQL syntax; I have tried it in many ways, but it always gives this error. Here are two of my attempts: SELECT 'category'. * , 'event'. * FROM category, event WHERE 'categ...

asked by 23.11.2016 / 16:05

2

answers

Group By by Date

I have a table named tsc , with the properties ID and DataHoraOcorrencia . I need to query the amount of ID and DataHoraOcorrecia . SQL SELECT DataHoraOcorrencia as DataHora, COUNT(tsc.ID) as Quan...

asked by 10.11.2017 / 14:13

1

answer

How to open an .fdb file?

I need to open a database file ( .fdb ), but I do not know how. What should I do to open this file? There is a list that I want to pass to Excel.

asked by 12.02.2016 / 15:53

3

answers

How to select all tables in mysql

What is the query that makes me query a certain database in mysql that brings me all its tables?

asked by 11.03.2016 / 18:23

3

answers

(SQL) About parentheses in the WHERE clause

Hello, I have not found a lot of information in searches I've done on ... but I have a problem currently that is as follows: I have a query with many simple conditions, just sequences of and . But today I needed to include some or , and beh...

asked by 18.05.2018 / 19:42

Questions tagged as 'sql'