我如何...根据字母表存储数据 [英] How do I...store data according to Alphabets

问题描述

我有一个任务：我需要根据字母存储字母。

例如：给地址为'anna nagar'所以以'a'开头的字母必须存储在'a '表和第2个字母'一个'所以它必须存储在'一个'表中检索它应该显示的数据anna nagar.please请帮我查询。

I have a task: I need to store the alphabets according to alphabets.
for ex:am giving address as 'anna nagar' so letter starting with 'a' has to store in 'a' table and coming to 2rd letter 'an' so it has to store in 'an' table on retrieving the data it should show anna nagar.please kindly help me with query.

推荐答案

您应该阅读关于计数表的文章，了解如何编写SQL来实现这一目标。



SQL Wizardry第八部分 - 理货表 [ ^ ]

You should read my article on tally tables for ideas on how to write SQL to do this.

SQL Wizardry Part Eight - Tally Tables[^]

这篇关于我如何...根据字母表存储数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！