SQL Tricks & Tips

Question 1

NO SQL means:

Answer 1

Not Only Sequel

Question 2

In T-SQL, what command will return only the first 1000 rows of a SELECT query?

Answer 2

top 1000

Question 3

Which type of join will only return results where the condition is true?

Answer 3

inner

Question 4

What type of filter condition can you use to return rows with a date value within a range?

Answer 4

between

Question 5

What must you also include in a SELECT statement when performing an aggregation?

Answer 5

group by

Question 6

Which function in T-SQL allows you to perform an aggregation across a range of rows?

Question 7

Which SELECT clause can you use to test if the outer queries value is present in the sub-query

Answer 7

exists

Question 8

To calculate a running total, what range should you use in your OVER clause?

Answer 8

rows unbounded preceding

Question 9

In T-SQL, what date function will return the last day of a given month?

Answer 9

eomonth

Question 10

Which clause do you use to create a common table expression in T-SQL?

Answer 10

with

Question 11

Besides the rank() function, what t-sql method can you use to return a ranking of results?

Answer 11

row_number