mysql - 如何获取一行中的某一数据

Question

sql中是否可以获取某一行下的某条数据？

目前我的结果是:

name                        Month_Number    Month   YEAR    Total_Amount Total_Retailfee Total_TransactionsSpar Group                  1               January 2013    46928270.04  269477.0855     100445Shoprite Checkers Pty Ltd   1               January 2013    83228663.71  290345.517      91282Pick n Pay (Pty) Ltd        1               January 2013    78518522.5   590395.6488     210117Pep                         1               January 2013    185792113.3  1847361.334     457374

但我需要这样的:

name       Month_Number Month   YEAR Description        Spar Group 1            January 2013 Total_Amount       46928270.04                                     Total_Retailfee    269477.0855                                      Total_Transactions 100445

Answer 1

如果我理解正确的话，你正在寻找这样的东西:

SELECT column_1, column_3, column_5 FROM myTable WHERE column_1 = "some_value"

这将仅选择该行中的某些值。