New problems-CodePudding

Set: the students in the table including (student id, name, language result and math), if you want to see each student corresponding math, how to write the select command

CodePudding user response:

Select name, mathematics result from the student table

CodePudding user response:

This is very simple,
Directly in

 
Select * from TB where username='student's name and & lt; Subject field name & gt; 
='mathematics'

CodePudding user response:

refer to the second floor morliz son hin reply:

this is very simple,
Directly in

 
Select * from TB where username='student's name and & lt; Subject field name & gt; 
='mathematics'

Well well, thank you??

CodePudding user response:

reference weixin_46373612 reply: 3/f

Quote: refer to the second floor morliz son hin reply:
this is very simple,
Directly in

Select * from TB where username='student's name and & lt; Subject field name & gt;
='mathematics'

Well well, thank you?

You're welcome, Rachel, please stick

CodePudding user response:

How the zha knot posted the junction post

?? I won't

CodePudding user response:

The point where the knot stick

CodePudding user response:

The top, there is a 'knot' button,
Point after, find out everyone's post, give a satisfactory answer, write ask post score, to score distribution completely, pull to the bottom, there is a 'complete knot stick,

CodePudding user response:

reference 4 floor morliz son hin reply:

Quote: reference weixin_46373612 reply: 3/f

Quote: refer to the second floor morliz son hin reply:
this is very simple,
Directly in

Select * from TB where username='student's name and & lt; Subject field name & gt;
='mathematics'

Well well, thank you?

You're welcome, Rachel, please post

How the junction post

CodePudding user response:

reference 4 floor morliz son hin reply:

Quote: reference weixin_46373612 reply: 3/f

Quote: refer to the second floor morliz son hin reply:
this is very simple,
Directly in

Select * from TB where username='student's name and & lt; Subject field name & gt;
='mathematics'

Well well, thank you?

You're welcome, Rachel, please post

The point where I didn't see the

CodePudding user response:

refer to the second floor morliz son hin reply:

this is very simple,
Directly in

 
Select * from TB where username='student's name and & lt; Subject field name & gt; 
='mathematics'

No, only in reverse

CodePudding user response:

I suggest you take a look at the BBS usage, that were lame, no one can save you,