SQL取出某字段中所有值为整数的数据

2014-1-6 liyangweb.com 李杨 MySQL

假如有下列表格

num

id  value
 1  100
 2  32.12
 3  45
 4  98.1

如何从表格中取出所有值为整数的数据呢?

灵活的利用取余,轻松搞定:

select * from num where value%1 = 0;

 

标签: SQL mysql

评论:

fishmackerel
2019-02-09 03:16
<a href="http://www.lagunawoodsre.com/nike-kd-trey-5-cielo-azul-rosado-zapatosk">nike kd trey 5 cielo azul rosado</a> <a href="http://www.highbacklink.com/mens-asics-gel-sendai-2-blue-orange-shoesi">mens asics gel sendai 2 blue orange</a> <a href="http://www.vuurogen.com/nike-air-max-90-premium-tape-qs-infrarot-schuhei">nike air max 90 premium tape qs infrarot</a> <a href="http://www.rsvppersonnel.com/nike-air-force-1-azul-high-top-zapatosp">nike air force 1 azul high top</a> <a href="http://www.shonema.com/kvinders-nike-air-max-thea-lyser%C3%B8d-appelsin-skoi">kvinders nike air max thea lyser酶d appelsin</a> <a href="http://www.enventsurvey.com/kvinners-air-max-90-hyperfuse-gr%C3%A5-gul-obuvq">kvinners air max 90 hyperfuse gr氓 gul</a>
fishmackerel http://www.fishmackerel.com/
shoesilove
2019-01-28 09:56
<a href="http://www.onewebsql.net/nike-mercurial-superfly-bianca-a-buon-mercato-kurpesa">nike mercurial superfly bianca a buon mercato</a> <a href="http://www.onlinne.net/nike-mercurial-vapor-gr%C3%B8nn-svart-kurpesc">nike mercurial vapor gr酶nn svart</a> <a href="http://www.onpointsports.net/nike-air-max-90-sneakerboot-orange-lilla-obuva">nike air max 90 sneakerboot orange lilla</a> <a href="http://www.oqibo.net/nike-flyknit-lunar-2-grau-jedi-schuhef">nike flyknit lunar 2 grau jedi</a> <a href="http://www.ourjourneychurch.net/jordan-superfly-2-svart-gr%C3%A5-chaussuresg">jordan superfly 2 svart gr氓</a> <a href="http://www.ouverturefacile.net/air-jordan-jumpman-team-lila-obuvd">air jordan jumpman team lila</a>
shoesilove http://www.shoesilove.net/
suchmeldungen
2019-01-28 07:18
<a href="http://www.ntygadget.com/nike-hyperrev-2015-black-and-gold-weapons-sneakere">nike hyperrev 2015 black and gold weapons</a> <a href="http://www.purchasetulsa.com/lebron-14-wei%C3%9F-and-gold-roshe-kurpesa">lebron 14 wei脽 and gold roshe</a> <a href="http://www.pennywave.com/sb-stefan-janoski-max-blue-volt-sneakerb">sb stefan janoski max blue volt</a> <a href="http://www.scoptix.com/air-max-2016-london-shoesg">air max 2016 london</a> <a href="http://www.domodrzwi.com/trucker-hat-quiksilver-hats">trucker hat quiksilver</a> <a href="http://www.magneticduo.com/adidas-rose-grey-orange-sneakerf">adidas rose grey orange</a>
suchmeldungen http://www.suchmeldungen.com/
diggingwp
2019-01-08 20:49
<a href="http://www.dbgbackoffice.com/nike-air-max-1-em-verkauf-schuhec">nike air max 1 em verkauf</a> <a href="http://www.flfireexpo.com/adidas-prougeator-absolion-instinct-fg-noirout-chaussurese">adidas prougeator absolion instinct fg noirout</a> <a href="http://www.gladatassen.com/adidas-nitrocharge-football-gul-r%C3%B8d-butyf">adidas nitrocharge football gul r酶d</a> <a href="http://www.quotesbymark.com/nike-air-max-1-essential-prize-bleu-scarpea">nike air max 1 essential prize bleu</a> <a href="http://www.thebatchseven.com/kaufen-billig-nike-air-max-95-trainers-schuhec">kaufen billig nike air max 95 trainers</a> <a href="http://www.vbchopshop.com/curry-3-light-blu-and-bianca-butye">curry 3 light blu and bianca</a>
diggingwp http://www.diggingwp.com/
nanterrelec
2018-12-30 20:27
<a href="http://www.dianaandwill.com/nike-air-max-excellerate-4-grau-scarpeb">nike air max excellerate 4 grau</a> <a href="http://www.newagecharger.com/nike-air-max-95-green-spain-shoeso">nike air max 95 green spain</a> <a href="http://www.foliekopen.com/nike-zoom-winflo-3-oransje-bl%C3%A5-kurpesb">nike zoom winflo 3 oransje bl氓</a> <a href="http://www.milapioffret.com/nike-air-max-95-premium-538416-700-31-zapatost">nike air max 95 premium 538416 700 31</a> <a href="http://www.kalraslan.com/custom-painted-converse-uk-shoesz">custom painted converse uk</a> <a href="http://www.umuttekelbayi.com/nike-free-run-metallic-gull-schuheb">nike free run metallic gull</a>
nanterrelec http://www.nanterrelec.com/
linexcanton
2018-12-29 20:19
<a href="http://www.atolyekarinca.com/texas-rangers-womens-hat-updates-hatd">texas rangers womens hat updates</a> <a href="http://www.dfarrie.com/blue-black-mens-nike-air-max-lunar-1-shoes-runninge">blue black mens nike air max lunar 1 shoes</a> <a href="http://www.mwsuperstore.com/air-jordan-11-retro-hvid-schuhea">air jordan 11 retro hvid</a> <a href="http://www.shanamorgan.com/air-jordan-retro-17-mintgr%C3%B8n-s%C3%B8lv-scarpeb">air jordan retro 17 mintgr酶n s酶lv</a> <a href="http://www.crisgarrett.com/womens-nike-air-max-bw-white-netherlands-shoeso">womens nike air max bw white netherlands</a> <a href="http://www.rejuvmedia.com/wmns-flyknit-trainer-wolf-grigio-bianca-kurpesc">wmns flyknit trainer wolf grigio bianca</a>
linexcanton http://www.linexcanton.com/
conmelior
2018-12-29 05:02
<a href="http://www.clumsford.com/youth-stefen-wisniewski-limited-green-nike-jersey-nfl-philadelphia-eagles-61-therma-long-sleeve-nflx">youth stefen wisniewski limited green nike jersey nfl philadelphia eagles 61 therma long sleeve</a> <a href="http://www.mjchronicles.com/nfl-nike-buffalo-bills-25-lesean-mccoy-ash-backer-t-shirt-nflz">nfl nike buffalo bills 25 lesean mccoy ash backer t shirt</a> <a href="http://www.moviezluv.com/nike-free-3.0-v2-salg-kurpesa">nike free 3.0 v2 salg</a> <a href="http://www.oregoncuisine.com/maschio-nike-air-max-2017-rosso-gituttio-butyg">maschio nike air max 2017 rosso gituttio</a> <a href="http://www.perokokbijak.com/nhl-minnesota-wild-3-way-fidget-spinner-d116-yellow-nflx">nhl minnesota wild 3 way fidget spinner d116 yellow</a> <a href="http://www.primehostinc.com/kvinders-nike-air-max-95-premium-em-l%C3%B8b-sko-butyd">kvinders nike air max 95 premium em l酶b sko</a>
conmelior http://www.conmelior.com/
carlandcodys
2018-12-28 20:17
<a href="http://www.dbgbackoffice.com/kvinders-nike-free-run-4.0-gr%C3%B8n-sort-obuvd">kvinders nike free run 4.0 gr酶n sort</a> <a href="http://www.flfireexpo.com/nike-air-max-lunar-90-gr%C3%B8n-guld-scarpea">nike air max lunar 90 gr酶n guld</a> <a href="http://www.gladatassen.com/jordan-3-retro-schwarz-cem%C3%A4nnert-schuheb">jordan 3 retro schwarz cem盲nnert</a> <a href="http://www.quotesbymark.com/tigers-blank-black-fashion-stitched-mlb-jersey-nflr">tigers blank black fashion stitched mlb jersey</a> <a href="http://www.thebatchseven.com/blues-99-wayne-gretzky-light-blue-ccm-throwback-stitched-nhl-jersey-nflx">blues 99 wayne gretzky light blue ccm throwback stitched nhl jersey</a> <a href="http://www.vbchopshop.com/air-jordan-retro-1-kvinders-guld-gr%C3%A5-schuhef">air jordan retro 1 kvinders guld gr氓</a>
[url=http://www.carlandcodys.com/]carlandcodys[/url]
bydecode
2018-12-27 09:05
<a href="http://www.tragemaus.com/mennns-ralph-lauren-beach-shorts-svart-gr%C3%B8nn-polox">mennns ralph lauren beach shorts svart gr酶nn</a> <a href="http://www.treehousecats.com/mens-nike-jacksonville-jaguars-4-josh-lambo-game-white-nfl-jersey-nflz">mens nike jacksonville jaguars 4 josh lambo game white nfl jersey</a> <a href="http://www.wetakids.com/adidas-zx-700-w-zwarte-lage-kondisko-kurpesd">adidas zx 700 w zwarte lage kondisko</a> <a href="http://www.dkslawn.com/lebron-james-christmas-day-jersey-nflz">lebron james christmas day jersey</a> <a href="http://www.tikihutkit.com/air-jordan-18-lyser%C3%B8d-gul-obuvd">air jordan 18 lyser酶d gul</a> <a href="http://www.allyoucankiss.com/nike-mercurial-superfly-really-billig-scarpec">nike mercurial superfly really billig</a>
bydecode http://www.bydecode.com/
爱浮夸
2014-01-10 20:39
不错的网站。
liyangweb.com 李杨
2014-01-11 22:23
@爱浮夸:谢谢~~~

发表评论:

Powered by emlog 冀ICP备13011830号-1