登录
  • #数学|统计

两道‌‌‍‍‌‍‍‌‍‍‌‌‌‌‌‍‌‍‍‌‍‌‍‌‍‍‍‍‍‌‌‍take home SQL题

dynatang
557
5
1. write a function to capitalize teh first letter of a word in a given string;

Example: inicap(UNITED States of AmERica)=United States of America

2. write a procedure to split columns into rows using a delimiter

schema

Id Name

_______

1 smith

2 Julio|Jones|Falcons

3 White|snow

...

Row 3 would look like >>"3, White", "3, Snow"
5条回复
热度排序

发表回复