Recent questions tagged Sql

0 votes

Q: SQL performance for select from where result of table

I would like to ask for performance of SQL. This is my query: Select A.code ,A.name ,(Select B. ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jul 20, 2022 in Education by JackTerrance

0 votes

Q: Finding max of nullable date between two columns in db2

I have a table in Db2 called myTable. It has several columns: a | b | date1 | date2 ----- ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jun 14, 2022 in Education by JackTerrance

0 votes

Q: Finding max of nullable date between two columns in db2

I have a table in Db2 called myTable. It has several columns: a | b | date1 | date2 ----- ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jun 14, 2022 in Education by JackTerrance

0 votes

Q: Finding max of nullable date between two columns in db2

I have a table in Db2 called myTable. It has several columns: a | b | date1 | date2 ----- ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jun 10, 2022 in Education by JackTerrance

0 votes

Q: Format Calculated Data

I am trying to format of years and months in a manner like yy-mm I can calculate like this to ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 13, 2022 in Education by JackTerrance

0 votes

Q: Count of Items in one row but not in another

I have an access table that has in one column a list of groups and then another column that has a ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 13, 2022 in Education by JackTerrance

0 votes

Q: Format Calculated Data

I am trying to format of years and months in a manner like yy-mm I can calculate like this to ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 11, 2022 in Education by JackTerrance

0 votes

Q: Count of Items in one row but not in another

I have an access table that has in one column a list of groups and then another column that has a ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 10, 2022 in Education by JackTerrance

0 votes

Q: Format Calculated Data

I am trying to format of years and months in a manner like yy-mm I can calculate like this to ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 8, 2022 in Education by JackTerrance

0 votes

Q: Format Calculated Data

I am trying to format of years and months in a manner like yy-mm I can calculate like this to ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 7, 2022 in Education by JackTerrance