Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/22

Click to flip

22 Cards in this Set

  • Front
  • Back
Aggregate functions: What does AVG(column_name) do?
Returns the average value of a column.
Aggregate functions: What does COUNT(column_name) do?
Returns the number of rows (without a NULL value) of a column.
Aggregate functions: What does COUNT(*) do?
Returns the number of selected rows.
Aggregate functions: What does FIRST(column_name) do?
Returns the value of the first record in a specified field.
Aggregate functions: What does LAST(column_name) do?
Returns the value of the last record in a specified field.
Aggregate functions: What does MAX(column_name) do?
Returns the highest value of a column.
Aggregate functions: What does MIN(column_name) do?
Returns the lowest value of a column.
Aggregate functions: What does SUM(column_name) do?
Returns the total sum of a column.
Aggregate functions: What does FIRST(column_name) do?

(not supported in SQLServer2K)
Returns the value of the first record in a specified field.
Aggregate functions: What does LAST(column_name) do?

(not supported in SQLServer2K)
Returns the value of the last record in a specified field.
Scalar functions: What does UCASE(c) do?
Converts a field to upper case.
Scalar functions: What does LCASE(c) do?
Converts a field to lower case.
Scalar functions: What does MID(c,start[,end]) do?
Extract characters from a text field.
Scalar functions: What does LEN(c) do?
Returns the length of a text field.
Scalar functions: What does INSTR(c,char) do?
Returns the numeric position of a named character within a text field.
Scalar functions: What does LEFT(c,number_of_char) do?
Return the left part of a text field requested.
Scalar functions: What does RIGHT(c,number_of_char) do?
Return the right part of a text field requested.
Scalar functions: What does ROUND(c,decimals) do?
Rounds a numeric field to the number of decimals specified.
Scalar functions: What does MOD(x,y) do?
Returns the remainder of a division operation.
Scalar functions: What does NOW() do?
Returns the current system date.
Scalar functions: What does FORMAT(c,format) do?
Changes the way a field is displayed.
Scalar functions: What does DATEDIFF(d,date1,date2) do?
Used to perform date calculations.