Providence Health & Services Interview Question: Give me a SQL statement.... | Glassdoor

Interview Question

Data Analyst II Interview Portland, OR

Give me a SQL statement.

Answer

Interview Answer

1 Answer

0

A SQL statement, I am assuming they are asking for a SQL Select statement.

Select field1, field2, field3
from table1 alias1 inner (left or full) join
table2 alias2
on alias1.tablekey/foreignkey = alias2.tablekey/foreignkey
where (filter records based on needed filter)

select field1, count(*)
from table1
where
group by field1
having

SQL statements are based on what you need to accomplish. You have DDL and DML and then you can do other types of sql like Dynamic SQL, T-SQL, PL-SQL, or LINQ.

Kevin on Sep 5, 2015

Add Answers or Comments

To comment on this, Sign In or Sign Up.