Informatics Practices
What will be returned by the given query?
SELECT RIGHT("LEFT", 2) ;
SQL Queries
3 Likes
Answer
+------------------+
| RIGHT("LEFT", 2) |
+------------------+
| FT |
+------------------+
Working
The RIGHT() function in SQL extracts a specified number of characters from the right side of a string. The second parameter, 2, specifies that we want to extract 2 characters from the right end of the string "LEFT". Therefore, the result will be "FT".
Answered By
1 Like
Related Questions
Out of the following, which crime(s) will come under cyber crime category ?
- Identify theft
- Invasion of privacy
- Online harassment
- All of the above
E-waste is harmful to the environment and human health if not properly treated or disposed of, therefore they must be handled with care. What are the health hazard which can be caused by E-waste ?
- Lung cancer
- DNA damage
- Brain damage
- All of the above
In the table 'Student' in MySQL, if column 'Fees' contains the data (5000, 8000, 7500, NULL, 5000, 8000), what will be the output after the execution of the given query?
SELECT COUNT(DISTINCT Fees) FROM student;Online …………… is a theft of personal information in order to commit a fraud.