Q&A BY TAG 'Select Query'

You must sign in to ask a question. If you do not have an account, you can register here

Create new records per column value
answered 28-05-2019 20:21:09 -0400

I have a table like this: Name job_1 job_2 job_n Paul Architect null null Eva Nurse MD null John Lawyer Seller Writer I need to create a ne...

Answers: 1

Select Query

Create Base view from SQL query
answered 15-02-2019 07:24:08 -0500

Hello there! I'm tottaly new on Data Virtualization and Denodo I'm trying to create my first view from SQL query (PostgresSQL) Would you guys could help me o that? <image src="https://drive.google.com/open?id=0B5D_BLEYhiEMU2lXNmZXY09CUHRpM3R0VVNx...

Answers: 1

Denodo Express PostgreSQL Select Query

Java Heap space error while running query
answered 13-02-2019 00:07:14 -0500

Hello, while executing select on a view, I am getting the error- "Finished with error: Error occurred in server thread; nested exception is: java.lang.OutOfMemoryError: Java heap space" Can you please help me on the issue, where I can increase the hea...

Answers: 1

Base view java Select Query 'Java heap space'

Using Regexp_like in Case in Select
answered 27-09-2018 11:26:31 -0400

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

Answers: 2

REGEXP_LIKE Select Query CASE

select top 2 * from table
answered 29-04-2016 21:39:06 -0400

Hi Team, Am looking for to query top few rows from the tables. I used below query select top 2 * from table . Please correct the query. Thanks Saraswathi C

Answers: 1

Select Query