Viewing 15 posts - 31 through 45 (of 133 total)
i try to extract valid credit card data. But i was not able to do so ,since data is not in good format.
SQL was never meant to be used...
December 6, 2016 at 10:49 am
in my table, the column names are dynamic ..
SQL does not work this way. By definition, the columns of a table are known and constant and it is...
December 3, 2016 at 11:04 am
>> We know what orphans are and you made your point clear. <<
No, we do not. We will have to make assumptions. My guess (and it is only a...
December 3, 2016 at 10:56 am
The collection of trees is called a forest. A single node by itself is a degenerate tree. Each of the trees in the forest will have a root, so the...
December 2, 2016 at 12:14 pm
Why? One of the major concepts in RDBMS and SQL is to get away from any physical storage. :w00t:
November 30, 2016 at 6:32 pm
>> I HAVE A TABLE HAVING THREE COLUMNS <<
Where is the DDL for this table? Why do not the column names follow ISO 11179 rules? What is the key for...
November 30, 2016 at 6:30 pm
In the future, would you please follow forum rules and post DDL along with sample data? Depending on what your data actually looks like, you will need to use some...
November 30, 2016 at 5:44 pm
>> I need a query to find out all orphans over a hierarchical table <<
``
I never heard this term before, and I wrote the standards. I think you are trying...
November 30, 2016 at 5:42 pm
>> I have 2 TRIGGERs on the same table. <<
The reason we put triggers in the SQL standards when it was on the committee was that the original SQL...
November 21, 2016 at 9:42 am
Thank you for trying to post DDL. But tables must have a key, by definition. You have mixed data and metadata in the same table; a measurement name and a...
November 21, 2016 at 9:12 am
You have no idea how SQL works and you need to stop what you are doing, and take some time to do more research and studying. Look up what a...
November 21, 2016 at 8:34 am
You have no idea how SQL works and you need to stop what you are doing, and take some time to do more research and studying. Look up what a...
November 21, 2016 at 8:33 am
>> I guess that the MAX(rowCreatedDT) will execute 3 times in this SELECT. Since there isn't an INDEX on rowCreatedDT and the table has more than 4 million rows. This...
November 21, 2016 at 8:30 am
The error message makes perfect sense and is quite clear. What are you taking a maximum of? Where is the group by, or over clause?. See you can find a...
November 18, 2016 at 9:13 am
SQL programmers hate triggers, because they are procedural code and this is a declarative language. Anything you can do to avoid them is good. But I also see you do...
November 15, 2016 at 12:56 pm
Viewing 15 posts - 31 through 45 (of 133 total)