Question
Which is used to find similar character/string in
SQL?Solution
The SQLÂ LIKEÂ clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator. The percent sign (%) The underscore (_) The percent sign represents zero, one or multiple characters. The underscore represents a single number or character. These symbols can be used in combinations.
In a mixed school 25% of the scholars are infants under 7 and the number of girls above 7 is 4/5 of the number of boys above 7, and amounts to 120. Find...
In an election between two candidates Abhay and Bharti, Abhay got 55% of the total valid votes, 20% of the total votes were invalid. If the total number...
In an election between two candidates, winner got 55% of total valid votes. If total number of votes cast were 2000 out of which 6% were invalid, then f...
If 15% of 'x' equals 45% of '60', what is the value of 'x'?
The income of ‘A’ increases by 20% every year. If his income 2 years hence from now will be Rs. 86400, then find his income a year before from now.<...
X spends 45% of his salary and saves the remaining. After his salary is increased by 15%, he saves 45% of the increased amount besides the amount he use...
The number of boys and girls in a school is 280 and 340 respectively. 35% of boys left the school while 10 girls took admission in the school. Find the ...
'X' scored 236 marks in Maths and failed by 64 marks as passing percentage is 40%. How many marks he needs to score to get 70% marks in Maths?
A Fruit seller purchased 1530 bananas at the rate of Rs. 20 per dozen. 90 bananas get rotten. In order to make a 20%, he must sell the remaining bananas...
In a college, 70% of the students opted for cultural activities. Among those, 50% participated in music events and the remaining 105 students took part ...
Relevant for Exams:
