Question:
What is the output of the following SQL query?
\[
\text{mysql} \,>\, \text{SELECT RIGHT("PRAYGRAJ", 3);}
\]
What is the output of the following SQL query?
\[
\text{mysql} \,>\, \text{SELECT RIGHT("PRAYGRAJ", 3);}
\]
Show Hint
The RIGHT() function extracts a specified number of characters starting from the right of the string.
Updated On: Apr 24, 2025
- PRA
- PRAYAG
- RAJ
- PRAYAGRAJ
Hide Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
The RIGHT() function in SQL is used to return the specified number of characters from the right side of the string. In this case, the query selects the last 3 characters from the string "PRAYGRAJ", which are "RAJ".
Was this answer helpful?
0
0
Top Questions on SQL
- Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
On a relation named Loan of a bank:
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)?
View More Questions
Questions Asked in CUET exam
- The components of computerized accounting system refer to:
- CUET (UG) - 2024
- Using a Computerized Accounting System
- S and T are partners in a firm sharing profits in the ratio of 3:2. They admit U as a new partner. S surrenders \(\frac{1}{4}\) of his share and T surrenders 1/3 of his share in favour of U. Sacrificing ratio of S and T will be:
Choose the correct answer from the options given below:- CUET (UG) - 2024
- Profit sharing ratio
- Calculate goodwill on the basis of two years’ purchase of average profit of the last four years. Profit/Loss of the last four years is given below:
• 2020: 1,00,000
• 2021: 1,50,000
• 2022: 2,20,000
• 2023: (70,000)
Additional information: Closing Stock of the year 2022 was overvalued by 20,000.- CUET (UG) - 2024
- Profit and Loss Account
- A die is rolled thrice. What is the probability of getting a number greater than $4$ in the first and second throws and a number less than $4$ in the third throw?
- CUET (UG) - 2024
- Probability
- Six people E, H, K, M, S, and U are seated in a circle facing the center. U and H are immediate neighbors of M. E is the only person sitting between K and S. H is to the immediate right of S. Who is to the immediate right of U?
- CUET (UG) - 2024
- Statements and Inferences
View More Questions