我希望在Age字段内写入查询 [英] i want write query within th Age field
问题描述
选择t1.Gender,t1.Religion,t1.Caste,t1.Age,t3.Image
来自Ushadi的
为t1
内部加入RshiHabit为t3
on t3.FId = t1.Id
尊重先生,
我想使用从Ushadi中选择Age,其中@minage和@maxage之间的年龄这个语句在t1.Age字段中查询,如:
选择t1.Gender,t1.Religion,t1.Caste,t1.Age(选择年龄来自Ushadi,其中年龄介于@minage和@maxage之间),t3.Image
来自Ushadi作为t1
内部加入RshiHabit为t3
on t3.FId = t1.Id
我该如何使用这个qyery在t1.Age?
plz回复...
select t1.Gender,t1.Religion,t1.Caste,t1.Age,t3.Image
from Ushadi as t1
inner join RshiHabit as t3
on t3.FId=t1.Id
Respected Sir,
I want to use ""select Age from Ushadi where Age between @minage and @maxage"" this statement query within t1.Age field like;
select t1.Gender,t1.Religion,t1.Caste,t1.Age(select Age from Ushadi where Age between @minage and @maxage),t3.Image
from Ushadi as t1
inner join RshiHabit as t3
on t3.FId=t1.Id
how should i use this qyery within t1.Age?
plz reply...
推荐答案
如果要获取年龄介于范围之间的记录,则将查询写为beow ...
if you want to fetch records having age between range then write query as beow...
select t1.Gender,t1.Religion,t1.Caste,t1.Age,t3.Image
from Ushadi as t1
inner join RshiHabit as t3 on t3.FId=t1.Id
where
t1.Age between @minage and @maxage
快乐编码!
:)
Happy Coding!
:)
这篇关于我希望在Age字段内写入查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!