Recent questions tagged Sql

0 votes

I need to give rank to records based on follows Based on b_id and priority combination need to rank ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 1, 2022 in Education by JackTerrance

0 votes

Q: Select all rows that matches any from other table

Get all Users from first table that have any word matching in another table; I have Users table that ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 21, 2022 in Education by JackTerrance

0 votes

Q: Calculating Trailing Twelve Months Revenue on PostgreSQL

I have a table with the following structure: yyyymm Revenue ... ... 201701 450 201701 600 201702 ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 21, 2022 in Education by JackTerrance

0 votes

Q: Calculating Trailing Twelve Months Revenue on PostgreSQL

I have a table with the following structure: yyyymm Revenue ... ... 201701 450 201701 600 201702 ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 21, 2022 in Education by JackTerrance

0 votes

Q: Select all rows that matches any from other table

Get all Users from first table that have any word matching in another table; I have Users table that ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 20, 2022 in Education by JackTerrance

0 votes

Q: bWAPP- SQL injection Hack displays a white screen?

I've been following this video( to install bWAPP on Parrot ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 14, 2022 in Education by JackTerrance

0 votes

Q: sql delete row when a column match

i want to delete the wullfi row by match the authid i must also say the aid is change so cant ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 7, 2022 in Education by JackTerrance

0 votes

Q: Removing white spaces and special characters from SQL

I have a table where I have a ColumnA which has data with white spaces and special characters. I ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 7, 2022 in Education by JackTerrance

0 votes

Q: How can I query a list of values into a column of rows using SQLite?

I would like to take a list of names (e.g. john, mary, paul) and create a SQLite "select" ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 7, 2022 in Education by JackTerrance

0 votes

Q: How can I set a criteria for SQL function?

I'm using the Microsoft Access to do the SQL and is there any way for me to set the criteria for ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 3, 2022 in Education by JackTerrance