- ©«¤l
- 7
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 54
- ÂI¦W
- 53
- §@·~¨t²Î
- Windows10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »O¥_
- µù¥U®É¶¡
- 2023-4-20
- ³Ì«áµn¿ý
- 2024-7-10
|
µÐÂÄ·O´d¡G
±z¸Õ¸Õ¡GsqlTranslate sqltranslate.app
Human Language¡G
½Ð°ÝSQLn«ç»ò¼g¤~¯à§ä¥X^¤å¦¨ÁZ³Ì§CªÌªº°ê¤å¡B¼Æ¾Ç¤À¼Æ(©m¦W+°ê¤å+¼Æ¾Ç)¡H
¸ê®ÆªíÃöÁpµ²ºc¦p¤U¡G¦³4Ó¸ê®Æªí¡A¥HIDÄæ¦ì§@ÃöÁp¡G
¾Ç¥Í°ò¥»¸ê®Æ
¼Æ¾Ç¦¨ÁZ
°ê¤å¦¨ÁZ
^¤å¦¨ÁZ
----------------
SQL¡G
- SELECT s.Name, m.Score, c.Score
- FROM Student s
- INNER JOIN Math m ON s.ID = m.ID
- INNER JOIN Chinese c ON s.ID = c.ID
- INNER JOIN English e ON s.ID = e.ID
- WHERE e.Score = (SELECT MIN(e2.Score) FROM English e2)
½Æ»s¥N½X
·P®¦·P®¦¡@Æg¼ÛÆg¼Û¡@sqltranslate¤jµÐÂÄ¡@«nµLªüÀ±ªû¦ò
±z¤]¥i¥H°Ý°ÝchatGPT¤jµÐÂÄ¡BBing¤jµÐÂÄ©ÎYouChat¤jµÐÂÄ¡C·P®¦·P®¦¡@«nµLªüÀ±ªû¦ò
ps.ªì¨Ó¥E¨ì¡A¥Ø«e§ÚÁÙ¨SÅvµoªí³sµ²¡A¨£½Ì¡C |
|