KnowledgeBoat Logo
|

Informatics Practices

Match the following SQL functions/clauses with their descriptions:

 SQL Function Description
P.MAX()1.Find the position of a substring in a string.
Q.SUBSTRING()2.Returns the maximum value in a column.
R.INSTR()3.Sorts the data based on a column.
S.ORDER BY4.Extracts a portion of a string.
  1. P-2, Q-4, R-3, S-1
  2. P-2, Q-4, R-1, S-3
  3. P-4, Q-3, R-2, S-1
  4. P-4, Q-2, R-1, S-3

SQL Queries

1 Like

Answer

P-2, Q-4, R-1, S-3

Reason —

  1. The MAX() function is used to return the maximum value from a specified column in a database table.

  2. The SUBSTRING() function extracts a portion of a string based on specified starting position and length.

  3. The INSTR() function returns the position of a substring within a string.

  4. The ORDER BY clause is used to sort the result set based on one or more columns in ascending or descending order.

Answered By

2 Likes

Related Questions