05/17/19

Why does Microsoft Access have a SQL view?

Can I use the OR operator or AND operator between two if..else statement?

Can/Should I use the OR operator or AND operator between two if..else statement? If [statement] end if OR If [statement] end if
Sql

04/20/19

SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints?

I need to write a query on SQL server to get the list of columns in a particular table, its associated data types and their length and if they are not null. I have managed to do this much. But now... more

04/20/19

Do I need to call rollback if I never commit?

I am connecting to a SQL Server using no autocommit. If everything is successful, I call commit. Otherwise, I just exit. Do I need to explicitly call rollback, or will it be rolled back... more
Sql

04/01/19

Difference between EXISTS and IN in SQL?

What is the difference between the `EXISTS` and `IN` clause in SQL? When should we use `EXISTS`, and when should we use `IN`?
Sql

03/18/19

What is the difference between single and double quotes in SQL?

What is the difference between single quotes and double quotes in SQL?

Statistics question

Suppose we are with a real estate agency that hasthe following houses listed in a specific geographicarea. $150,000; $146,000; $152,000; $155,000;$143,000; $157,000; $180,000; $148,000;... more

Zelma is 18 years older then her son. She was 3 times as old as he was 1 year ago. How old are they now?

Zelma is 18 years older then her son. She was 3 times as old as he was 1 year ago. How old are they now?

11/06/15

Given 3, 9, 15………. Find : the 20th term and the sum from first to 20th term.

Given 3, 9, 15………. Find : the 20th term and the sum from first to 20th term.

Develop a solution to calculate and print out these values.

mrs. brown has given a test to his class. He would like to have the average score for the class as well as the highest and lowest scores.Use a trip value to stop the processing of the loop.

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.