100 glasses are there. A servant has to supply glasses to a
person If he supplies the glasses without any damage he
will get 3 paise otherwise he will loose 3 paise. At the
end of supplying 100 glasses if he gets 270 paise, how many
glasses were supplied safely.
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 12449 }
Table name: T1, it has only one column.
col1
------
c
b
a
b
b
b
b
d
s
a
a
t
s
Requirement:
I need the following output from the above base table by
using SQL query.
col1 Cnt
----- -------
a 3
b 5
Others 5
Please help.
Thanks
Guru
v.gurus@in.com
Answer
Is This Answer Correct ? | 1 Yes | 0 No |