Top What's New Develop Technic Contact
ƒƒ“ƒ|ƒCƒ“ƒg

[MS SQL Server]

’Šo‚·‚ιƒf[ƒ^”‚πŽw’θ‚·‚ιFTOP

[ŠT—v]

SQL Server‚©‚ηSELECT•Ά‚Ε’Šo‚·‚ιƒf[ƒ^”‚πŽw’θ‚΅‚ά‚·BŠY“–ƒf[ƒ^‚̐ζ“ͺ‚©‚η‚̐”‚Ι‚Θ‚θ‚ά‚·‚̂ŁABETWEENqŒκ‚ΖŽg‚’•ͺ‚―‚ι‚Ζ•Φ—˜‚Ε‚·B

[\•Ά]

TOP n

n=ƒf[ƒ^”

[ƒTƒ“ƒvƒ‹]

‰Ί‹L‚ΜƒTƒ“ƒvƒ‹‚ł́uZŠ˜^vƒe[ƒuƒ‹‚©‚ηζ“ͺ‚Μ‚PŒ‚Ύ‚―‚π’Šo‚΅‚ά‚·B

SELECT TOP 1 * FROM ZŠ˜^