ورود

View Full Version : کمک در مورد نحوه استفاده از دستور select برای این جدول



mrt_Azm
چهارشنبه 25 اردیبهشت 1392, 19:44 عصر
سلام اساتید محترم SQL
در جدول زیر من اطلاعات مانده حساب مشتریامو در تاریخ های مختلف دارم
سوال :
میخوام مشتریانی که مانده حساب انها به صفر نرسیده نمایش داده بشه لطفا راهنمایی بفرمایید

کد نام خانوادگی تاریخ مانده حساب
1 علیمحمدی 17/01/1392 60000
2 علیمحمدی 31/01/1392 30000
3 علیمحمدی 12/01/1392 0
4 رضاحبیبی 19/01/13927 5000
5 رضاحبیبی 31/01/1392 50000
6 محمودمتقی 21/01/1392 25000
7 محمودمتقی 30/01/1392 15000
8 محمودمتقی 04/02/1392 10000
9 میرزاژیان 19/01/1392 45000
10 میرزاژیان 31/01/1392 60000
11 میرزاژیان 04/02/1392 20000
12 میرزاژیان 17/02/1392 0

http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAoYAAAFiCAIAAAD k1Y4nAAAgAElEQVR4nO2dO7qcuhKFe6jOT9Zz2CNwSOIpnGQHz MCOyRzcnPBMoG/QPCRVSTxaKi3B+j8Cuxux6aqlWiAEPF6EEEIIAeBRewcIIYQQ8 nrRkgkhhBAQJkt+EEIIIcSWqCX/9/dvu0vr+9/cwoBzObFQNmgLM1I9/rRkLgw4lzoLZYO2MCPV409L5sKAc6mzUDZoCzNSPf60ZC4MOJc 6C2WDtjAj1eNPS+bCgHOps1A2aAszUj3+tGQuDDiXOgtlg7YwI 9Xjb2jJ31+Pr2/x+ffPH7/+d3hrG63aFtYaqD///vjx75/a+7NjaTvgu5Y///54aAJelu+f0W/9PCod4fvn4+v30V1qUCfBcgPZxOoe6AKUEeu4bXZSo/gbWfLvr8fj4Va075/LfVgHfvneVkDC+iRQf379cyw+1ZZ2A743I48f//75+78/fyKrff98PB6xw0Qnj6Ij/P3v79///frxeDz++RXbeHyvWtNJsDQnm99fp9P0598fa/E6fPh1s4yo3aTsstVJzeJvY8mzlX59T7/cZc8vP9gKRFgfBar+zhxYmg34djp+fk+WGXfNpdpultpc+W1VJ 8HSmmySB16x9dc0ff/7689/37+QxzMwMlJX3jX/upklzzXr6/u/76/VVpPi/v3lDyPsa7X8sBq5zBqo+jtzYGk24MlFHAj+/J6/+v5yDHi/JefKb6s6CZZrymZd2ksTRkaM4uZZjPlfj8U/nyX/+fVP1CzXH7mccCSddVp/OSnZ18r7YfbRPLtMB2U/v/8qavBKP+7SVMB3L+uBYNB1Qw+eB7fjmZryKHv7fEi+IWxXJH/b1UmwtCKbtf64vMf8dtSxhtJUPSO/vx4/v/eb4mb3iW0qtBgnOxex5OlnrKcR0bis11QSV2WmPrAGelcr94fZ R/PU4lwdf/z490+ghunbQ5evqiztBPzAEj0QdMdsvr6dNadqO/1X+O4/v779/LrXFxNVIBDJX1FomtFJsLQhGzfdWm+NFL0m02SXke8vJW7TuNS Pf7y4bYU30X3iw6vCYmKd9O/u4+Y88f/Mkv/8+iemNu/48Y9eicQv/P0163vOjXN2Em1VU1gfLn9+/fOu42/pfP3SAwU/8NVMwI8uc5deysf/fv1Szoyn1b5+//WGu8VJrZ/fZVZnWPT9E6lQJN/RDgWvk2BpQjbLlC73XPnn91/dYvfUPeA0WWXkz78/lEOTcDRiPt7959efdUa022u2us/vL2/G1j+//sQtJtJJ154ucl0m/h9Z8vI7//v7dxKo/zPmryLjdaG5fv90frM27W3v9IomuroyGibUEEQVdmki4J+kyVW yY88/pi49de/ZOL++ReLe/5X5nRf3urXzrSYSacl/W9FJsDQlm3fMv347hV6GfVfdA06TVUbeRzPapVwxBDVH25lrKS 1A7z7ujYtvc/mVtBi1k65jIfqfzh3/DyxZzoJefu3y1fwDfutjP4olb3MRS1Z+7M9vJ1A/fizhRR7paifg2vL9lRqU9lMTydq7rKwHi4GJvqvAkkc1v9oGUy L572+rOmlUNkHtDqqZNzQ4JUXUvUbSZJWRdKn/+qn3wj2kuo/bGWNEO+l0u1DZqQCPTweuRf3yp6Su0lTnR4hrCf61gR9fP5VGi Ss39sL6XJTOUKd3VdJTw56fXHdpIeDK8vtLn68gkJOrF5W+m6/H4wlLdu+nEpasTv7URdKuTlqUzRzqNUFBir2wx+peI2kyy4h+k jZ1mT/6fLoUybnT6zrbFpPspMUvJz8+n97lxU55AEK0lum6XD3+3TA8z Nmp5v37X29Zx8F0Gc1qQD6mbirgcvGvg/jHlz9DKc6LOzjk9E9xjWpiseRwMNPt7RvzRdUD8yZ1EiwtyGYp QW4WnGomRqH1utdImiwzovmuuLL7eDy+vn9/PR6PH/9+T0elYcOETcqJHUmLUTupc95c/Bl5j48tOXFx9+ht9Zl/mP0fPbgkqm17SwsBl4v/TIDgQkyWW4fz3H98EZHIpQXZfLuDHHvXr1T37pGRKy+fWfJyuO FdhFe+qvLDqgd3c/n9dZ1q20TAxZIYqf7sbGZ2989Pia4kErm0IBtPJJ4rvydXuw9D rl33Gs2If/3o1stpS5YyXWbQxRVs+8OqB3dzuZIQmwi4XOKXrM6PULkXyT7X/5VEIpc2ZKPNYxVqgah7bWYkPvv6fss5S/av73r1IvGV9Q+rHtzN5egj7JGXJgKuL+ceuq4vvv5znCpdSSRy aUg24XQkyLp3q4xccjlnyQ0sre9/cwsDzuXEQtmgLcxI9fjTkrkw4FzqLJQN2sKMVI8/LZkLA86lzkLZoC3MSPX405K5MOBc6iyUDdrCjFSPf9SSCSGEEG JJ1JJfLdP6/jcHA05OQNmgwYzUhZZM8sCAkxNQNmgwI3WhJZM8MODkBJQNGsx IXWjJJA8MODkBZYMGM1IXWjLJAwNOTkDZoMGM1IWWTPLAgJMTU DZoMCN1oSWTPDDg5ARVZDN03ZD8+n0virvSOI7eCmIDY/98PPvxdYZU27F/hn/L25fsAHfkKTFnw9wGtSx57J9lAwssrN0MXUPiu0LAiTnlZSNKz dg/57I+9s9HN/ieOBuyZ8pD5ziB9x9no8nemqh4bttwNWdnnQ+SRxQfAtqRx/75UBJzPSpZ8lv2NxTWXiYB0pLJtSkuG1FqXMt9iCrvmvTS/3w70Dxh05ETFU8eD8i9nT8xqAuQHXno1iB8Mh7RAFUseVF4QU+ GFNZ+2huiaTzgpA7lR+OU812N9bT5ve7QLR8qTYKOueUSqYrnt E3sbbAn96qc2sjA0LdTGw9R15ILOg6gsI4QWvLcF3E9uvGAZ6a paw41sbJkJx2aKWuj1vGPhT10GyaZqHhuW2U196P1ZP1mZ8n+U EF7I4iHqGLJ+gSKvAAK6wie7PyCAHoZpfGAn2Sukt5MoF0lwxk MBc2oCcVlo5SaROgD712+dpqkXfXAbmhtE3v77Lryg4svyI6sX Di4bq+pZMnlB2YBhXUEp6x7EzzmS114NB7wU6gzgRRPloU2Mnw 6NcEfE8lGedkopWZxORnf6CyieMVSHFmZAKa3F2211WwPyTE7s nDlIDUiL/LDnavVppYlTzKjJUdYq/r7X5g27NJ4wE8QXATsuk4fWlOMe+jUmUPvb931sapFAQxko5Sa 7YEM2e2CiVbe58ogiVhZq3gRN9dWMxMEaEeODG2o0ZYf7lwNgW qW7M1oLACosPYSniW7YJbpxgO+E2dSSTgXR9wnM301rdcN2iSg NblhodDXvxwGstFKzeYZgTTtNS8eKUdWxk7E6a+46VgrjMEsr6 JAduTY/Dg12vLDnatBUM2S3RmNJYAU1sx6kuR8shsY8XhABzwTwQ2kXla eT+V6V5A29ZrYxvqY2c6GhWyUUrN5RqB4gHofk34dOTpG6n0ab ysaG96BgdiR0z+fA9d5EPfA5wVRWDO+DA7VaVkTUEAOeCa8ezH k4IXnyetknC28qbTat3V/dGEsZKOUmu3LQfL6f2QzuzMUtI+1VQtj6UFFB8COXP4xFkDI+J ta8i1nXPuHweHcDWdqj1up4UszcMBzEZ6/hCNfayq9i8LPflzru9dGPy5z1ofP+seYWbJfanacEAgXlJs5dm XBbx9tqxfG4g/tWsDryO5zQq5PPUtWHxSbDzxhLfjH38EZUrPKAw54LqK37uGNf jWDiWyUUrPrib7BBabwcdNHr/W7u5FoqxfGsuXSAa8jm/10CCpaclmA9z81Ut1uYQcOeC6umbi63EA2jcGM1IWWXIF4aW+4 sCMHPBvppzGS49xCNk3BjNSFllwJacuNj82gBzwXqWcWkMPcRT btwIzUhZZM8sCAkxNQNmgwI3WhJZM8MODkBJQNGsxIXWjJJA8M ODkBZYMGM1IXWjLJAwNOTkDZoMGM1CVlyYQQQgixJGrJpQ8Hit L6/jcHA05OQNmgwYzUhZZM8sCAkxNQNmgwI3WhJZM8MODkBJQNGsx IXWjJJA8MODkBZYMGM1IXWjLJAwNOTkDZoMGM1KWOJY+j80jgM u/5oLCMYcDJCarIZuiSFUd749dmyTr6WqhY2419Kw9gR64eE0uqW LL3LrtCL7YDFNZhhq6h1xlcIeDEnPKyEa9hdN6VPPbPRzeEnrj ejbI4wWbJ2nTkxNsgnbYb+7brlZIfAteRN2JyNSpYsvIeJJ4lh 0xBakh2jQec1KG4bN4O61SY2Nu81teXz0X/4RllsmRteoTYDbVtet9SG8kHWkfeiMnlsLdkJcIljAdNWAeZok RLJtemsGwWM/XOdzXW07D3ukO3fLhdsrYcWe6G2nbHvpU3I7COfLv3odpbsgxy EYWBCesooSXPMcMVYuMBz0xT1xxqYmXJTjq0Iq+NWsc/DkvW0G1UMW031LapfUtsJCdwHTkVkwtSw5LdcaBioYUT1jG8gW tfk6ADNo0H/CSzlL2ZQLsuOjidADSjJhSXjTJXKxH6oPwvXydL1qYj67uhtk3 KIraRrOB15Ht1lSqWbDEuiyesQzhl3ZndsF7qwqPxgJ9CnQmke LIspZHhuGAA88LnAjPlZaPUmrnGK/H1LxvLS9BKE8WRlQlgenvZNrFvNtezADtyMiaRGcLyw52r1aaS Jc/aKucugMI6wlrV3//CtGGXxgN+gmCibNctt8b4nqwY99CpM4fe37rrY1WLAhjI5h1PL 5LbAxmy28VKVuI8V2kvXSLcYHLftI1kBrEjx2OiRlt+uHM1BGp Z8hQNWnKE8CzZBbNMNx7wnQz9Evxwto24T2b6apW6MgloTW5YK PT1L4eBbLzJ0xOb1iZNIFKyUo6sjJ14f1If8U7tm/ZbMgPZkWMxUaMtP9y5GgS1LLn4fH5IYc2sJ0nOJ7uBEY8HdMAz Edwi6mXl+RQ3yoi0KTfTbK6Pme1sWMjGmTw9s2ltyvRmtWTFXV UdI/U+jVyDTu6b8lsyA9mRN2PCgeuP8a6QFgBSWBO+DA7VaVkTUEAO eCbWO2ReStp8T3523c60LhcnYt/W/dGFsZCNUmu2LwfJ6/+RzezOUNA+2ja5b6XrJmhHbuXyXQZk/C0tuWCIIYX1xj/QDadTO1N73EoNX5qBA56L8AwlHPlaU+ldFH7241rfvTb6cZmzP nzWP8bMkpVJVOnoihMzuZljVxb89vG2yX0rXTdBO3L5IxEYqln ya+yfJZUFKaw3/vF3cIbU7IEgcMBzEb0HBW/0qxlMZKM8k3rXoymDC0xhyTp6rd/djVTb5L6VeSWAA2ZHtniUKAb1LLkwwPufGqluV3bAAc/FNRNXlxvIpjGYkbrQkisQL+0NF3bkgGfjdk/3K84tZNMUzEhdaMmVkLbc7JD1G/SA50IkrvG8VeYusmkHZqQutGSSBwacnICyQYMZqQstmeSBAScn oGzQYEbqQksmeWDAyQkoGzSYkbrQkkkeGHByAsoGDWakLilLJo QQQoglUUsufThQlNb3vzkYcHICygYNZqQutGSSBwacnICyQYMZ qQstmeSBAScnoGzQYEbqQksmeWDAyQkoGzSYkbrQkkkeGHByAs oGDWakLrRkkgcGnJyAskGDGalLBUseOounAlNYxjDg5AS1ZLNR hbT3cI7j6K0gNnD0ZY37227+6YywI9fF3JKdd1GP/fPRDZ8pOcoVhDV0Db1h6AoBJ+aYyEa8bHejCrkv/Frcz3sptvaG7M06lnjnr9tWrrb5p3PCjlwXa0uOvd0u+2Ff48K a3jdESybXxkI276LjlJh0FXJNeumCygtVg5q16chiN/S2YrXtP50VduS6GFuy3ftmGxfWFChaMrk25WWzOJp3vhuvQmP/nNYduuVDpUnQN7ccWe6G2nbX3hYtC+zIdTG2ZL07lFBY48IKLX kOG65HNx7wzDR1zaEmhpbsZCRVhYLvIh+Hzjp0G+eu2m4obffs bdm5OOzIdTG3ZHcYhsMvUbyBa79LWkyOO0HjAT/JrGZvGtCuiw5G/QAdC9koc7US0Q8McPnaaZJ21QO7obVN7235I717dmQc7C150Vd ZcTUuLKesO1NR1utceDQe8FOo04AUT5ZVNjJ2OjXBHxPJholsl MtAiSrkX7uVZqk0URxZmYWltxdttdUML2Q135FLz38rTAVLtpm 61Liw1hi9/4Vpwy6NB/wEwRXArltuTvEVrhj30KnTht7fuus3XFr2YSObd0i9YG5XIdnz psyIzhi6qptU2d7/kxE311azqQNNd+RY5BuihiWrkstN08KSZ8nKqRQYjQd8J0O/BD+ciCPuVJm+mtbrBm0G0JrccIBUX/9y2MjGmzw9sVmFpGmvqfFIObIyfCJOf8PtaXsb+dMFaLkjRyPf EFUsWZNcbqCFtZ4kOZ/sBlNp0AHPRHD3qH+g9BS3qoi0KbezbK6Pme1sGMnGmTw9s1mFl DnS6n1M+nVkdfhU7Ea8rV4haMnbcOD6OBZjscjC8jVzqE7b9Mo zIAc8E+vtMS8lbb4nP7tuZ1qXixOxb+v+6MIYycabkOF8lOxNc gpAZDO7kxS0j7VV/oz6WRFu0JGhkfG3suTC6gIWln8MHE6ndqb2uJUavjQDBzwX4cl LOEy2ptK7KPzsx7W4e2304zJnffisf4ylJfv2u6MKiRNpuZljF xf89tG2yt6qnxXhBh0ZmiqWnHqyXC6AheUffAdnSKDnwNsABzw XsbtYWh8qq4mVbJQHQ++qQsE1prF/fuDI/m4k2kaeoG1SHG7QkaGpY8kGAO9/aqS63cIOHPBcXDNxdbmBbBqDGakLLbkC8dLecGFHDng27B4Iex duIZumYEbqQkuuhLTlZoes36AHPBcicY3nrTJ3kU07MCN1oSWT PDDg5ASUDRrMSF1oySQPDDg5AWWDBjNSF1oyyQMDTk5A2aDBjN SFlkzywICTE1A2aDAjdUlZMiGEEEIsiVpy6cOBorS+/83BgJMTUDZoMCN1oSWTPDDg5ASUDRrMSF1oySQPDDg5AWWDBjN SF1oyyQMDTk5A2aDBjNSFlkzywICTE1A2aDAjdalgyeMYvAO+y BMJKSxjGHByglqyGbpk2dFe+jUXrnkF7V1Np592vtE2+hKy/MB1ZOUVWF4q9GQ0i70lv19kN+ivjc0HnLAklxJSCwEneJjIRry G0XlX8tg/H93ge6L7dpGli3pv4NRex7npyIm3Qbpt5Wrq/pQCrSOL91qHb46ezu2u8uoXa0t2HtpfVltowgqYOpn2mvJGpQU ecIKJhWzenc3pa7EXeq1vMJ9NeumOytvblM6b7LtiN/S2YjV1f8qB1pGDUikMeM1Mo5UzwNiSY4ef+e0ZTVg++jjUOHTP x+PZDS0qCzvgBJTyspEXyNKv2FxPwoZu+VBpEhjAliOnrtM5be Vq6v4UBKwjL5EPEhFY9HVM2diS9e5wv4HrWUccuCb3xtCSnTKT qkLBd5GPw647dBu9WdsNpa1cLbI/xUDryG5ElDNif/jiAp5sbsliBKiQK6EJyydhyXMPbE1c2AFHptWMZ8FCNsqYVOIC WmCB/tnqHlc9sBta23C12P6UAq8jz5F/dp0YaZiCtyan+bMce0uOXUfNDJ6wXCKW7B+utCUu7IDDIq5Rtp X1jzGRzVRxxBwh/Tgo2guVzTjfKKfN+iwt5VOvbbiacVVA7Mj+YUmQkum/8ohHm4OnfKiuVo8aljwFr2wUEIW14lnyPMl/ldf761VbiamaMGAHvBJu4tR/L/MoNsZFL4uNbJSKsz1PN+yF8ZOJ0FVdE5XtpSEobq7smdyfIkB2 ZKd7OHHx5157GVVTID+MZaoiVSx5ikPREEAKa8G15Pc06657Bt eTVulZHMJ8DHbA6+DOoI/9O1gbqzyUx0Y22mTlzV4lTTtSuFKOrAyXe39SG/GOTK02utkHsyMHs7zWD6ezmq4f3YMWNQXyQ8RhySqWnLodIBeY wlqITfpckeNW2J4MHvD8DF1kYPJzsDOdFSPZKJOVN+8pUuZIq4 VLv44cHTXVTWVrb/X9KQFoR1ZG/YduCsYcxWAcgQPX+zG4/xZUWDPKbY4efq9r4TQZPODZ8TvyVj7pxBGMZKNUnO1xYHl1MrK Z3YkL2sfaRuqjzSO8QDtyZITher2ooiXfUlgr3pzPzZvrDCL2I fABz4t/IhNOP3HunnTngur/vkQhOYulJQdPAdg+LxA2IDdz7CGa8uKn2jbW200eFoLakfXYX8 6Ra712QnlsaWZQhXUOm4cEfMS1Ar6Jf8YSFAfoYycsrGSjPI9o 16TJ4PJEWLiOPtba3Y1E2/jTk+TlktzAdmQ9hf5BMHaN3EUlSy5P6/u/Ip5Xg8l1Ar6L1Ei1PzHvOU08efajN7/6AtUjAzeTTQMwI3WhJSPj1X1sR75GwA8Q92RlqnzwmIkW5gYYc TfZ4MOM1IWWDIt/fRK+frcf8ONIWwY/bsLjjrLBhhmpCy2Z5IEBJyegbNBgRupCSyZ5YMDJCSgbNJiRut CSSR4YcHICygYNZqQutGSSBwacnICyQYMZqUvKkgkhhBBiSdSS Sx8OFKX1/W8OBpycgLJBgxmpCy2Z5IEBJyegbNBgRupCSyZ5YMDJCSgbNJi RutCSSR4YcHICygYNZqQutGSSBwacnICyQYMZqQstmeSBAScno GzQYEbqUsuS428fywSFZQwDTk5QRTZDlyw+/os334zj6K0gNnD0NY2xthv7Vh7gjlzcNRCoY8nT4/pLvkoBWFgz1xJYAwEneJSXjXgt8tg/59oz9s9HN4SeuN4guvRP722a2qs1Nx058XZmp+3Gvu16xfOHwH ZkA9dAoIolry/QKRdeWGG9mfp9YMlOh2wO8IATTIrL5t3TnI7mv2EttF/XCB+eUWprL2w6stgNtW1631IbyQdqR7ZwDQRqWLIn8FLhRRXWG 21o7PUah+75eDy7oUXFYQecgFJYNkut8c53NdZT0/e6Q7d8qDQJytaWI8vdUNvu2LfyngzakU1cA4HqllwquqDCmphD wIFrcm+sLNkpM5rxaaPW8Y/Dfjt0G11Z2w21bWrfEhvJCWhHNnENBCpY8qTBNcRFfAlUWBMJS 547ZWuiww44Mq1mPAvFZaMMSDnVPeyAgSUuXztNtlx1926obRP 7Ft9IVjA7so1rIGBvyY4GSyoMU1gzEUv2jwTbEh12wGERlynby vrHlJfNVGVcJ52DrhwERbugshnnG+W0OVhTby/bJvYttRP5gOzISdfQptspH+5crTbWlrxeq1n+VyYkkMJa8Cx57 J/L1at1jomrOYuJlp+CHfBKuIlT/73Mut8YGr0sBrJ5h9brQNuFJ+yCsRmZyfNcpb10iXCDyX3TNpI ZwI6ccA012vLDnashYG3JiwbHvutHTfmZABSWg2vJ72nWXfdcw uDN9nyZ9MPPwQ54HdwZ9LF/B2vDVYjCGMgm7E6v144uJY1x+uTAyLO/trIb+oh3at+035IZwI4cdw012vLDnatBYGzJQzf9+DnIN7Xk6N zKFfeMKvgEEvCA52foImOTn4Od6axYyMaZPD2zaW3K9Gb1FqS4 q6pjpN6nkWvQyX1Tfktm8Drylmtw4PoD9KJ1v4Fr7U5HD7+ntn CaDB7w7Ph9eSufu8BOcBksZKMMSmyfCshLlpHN7M5a0D7aNrlv 5R9dgNeR7VwDARn/opasVq4iscUTVoA3tXLzpjv/agoi8AHPi3+24heNblj+76Y29u9LF5gtzCxZmUSVjrk4WZWbOf YQTXlFNDE4nXrS191mXNu5BgLGluxeRS07exBPWJ9QfrjqY64V 8E38k6igaEAfO2FhIhvl0bW7ZkwG1ybmeZjO/w91Snc3Um2T+3bLtwNYuQYC5pZsRev7v+KccdXelRTXCfguUiP V/sS85zQh5dmP3vzqC1eVA9xMNg3AjNSFloyMV/exHfkaAT9A3JOVqfLBkyZamBtgxN1kgw8zUhdaMiz+9Un4+t1+ wI8jbRn8uAmPO8oGG2akLrRkkgcGnJyAskGDGakLLZnkgQEnJ6 Bs0GBG6kJLJnlgwMkJKBs0mJG60JJJHhhwcgLKBg1mpC4pSyaE EEKIJVFLLn04UJTW9785GHByAsoGDWakLrRkkgcGnJyAskGDGa kLLZnkgQEnJ6Bs0GBG6kJLJnlgwMkJKBs0mJG60JJJHhhwcgLK Bg1mpC61LLn4Cz0oLGMYcHKCWrIZuuSzT+Xbkl+vcRy9FcQGjr 4ZKtZ28w8VBbAjJwNiHqDC1LBk/8nAhcIJKKxrw4CTE5jIRrzt0Hkl8dg/H93ge6L7ePmlPnlv79Je5bXpyImXLoZ/XftDu94n+Tl4HTkV+clM4F8BsB97Sx66VeefHFZugCesi8OAR1 jr+4XqRjYsZPPOgHPs77/RJbRf16RdP9TXXtgsZmI31LbRP5RonhW0jpyM/PrlZTqXtSWP/VPIaugLRBNNWJeHAdcZx6Hv+vE1dF0/jlO9H7rrlJDPKC+bpWp757sa62nze92hWz5UmgQJ3HJkuRtq29 gfSjXPC1hHTkbes+uL9ChrS54C7JwlF4ollrCG7vLv7cMKOCpO Dbm4HnZiaMlOmdFMWRu1jn8sziu2eri2G2pb/Q8lmmcGriMnIu+fQV/Dk60tWX3xe4nihCSss0e4TdVvpICjUXwyY7tYyEaZq5XoWoEDL F87TbZcdfduqG0jfyjWPDd4HTka+Sly6/f4ZXIba0t+Ka5cJI5AwhKTRaYIhPMGg2BEhteCAS6YMg8UcDCc REqpw+XRGBPZKIdEcxVS4h6dfho/slIcWZkAprePtNVXNFAKYkfejJxePkWo5IfqalWpYMk2J38gwh r7PtSM9vOVKZ7r5UavRLhTPaCKOUjA4ZgnC3n/0EZDQfJojI1s3nH2Irx90ey9hlui/Mtu/ueR81ylvXqmp+2v7tR3tGQtIP60JC+davzlh7E01cXeko3mKWA IaynD838ez8YrImoAAB3+SURBVL5/30cXzjx/LGMwyrwRXV36+pXACDgebr9fJ+p4pQMqj8bYyMabPD2xaXDStL XhrVfakZXhcu9P6iPe+h/SfkV+IDuyEpAlcmPfrRPg1qnyQfzlhyY34x7H3JKtLqthCEsOP j+7zhu3f/a9N66pXmyPMa0PoSaMgNdATp+OTeltIY/GGMnGmTw9s2lwysmDeiOS7qrRgVNxgVhLu37Hk/Ir8oPZkfUb2eZzm9Vh9dvIX9EPOXBtdXMdiLCEwT77oY9bcoxn PyasGkNRGAGvgN+pDx1SIebRGCPZOEMT3kfJUiQvUEY2sztzQf t4W+UPRT/NDGZHFj9dP+y9QB+S8S9qye5obVlQhCXGLcXE/f5d0tWLzbFi76yPIkKUgFvjn7n4haJzxoS8KQTO5CK0PBpjacl +4dnhb+JEWm7m2BUHef0z0lZ7fkPs08xgdmTx09Vj3yt0IntLN hqdwxSWg0n3MgQ+4IXwT6WCQnGh/BbCSjZK5dn1gMrgqsTYPz9wZH83km3DPySblwK0I8uAzH2tGy5 1k6GxJdsBvf+JOzCaBTrgBUmNVF8pv4W4q2xwYUbqQku2Rn2k/QWADXhp4p5MR97mtrKBhRmpCy3ZkvBKY+39yQlkwK2Qtnyt5Jb j1rKBhBmpCy2Z5IEBJyegbNBgRupCSyZ5YMDJCSgbNJiRutCSS R4YcHICygYNZqQutGSSBwacnICyQYMZqUvKkgkhhBBiSdSSSx8 OFKX1/W8OBpycgLJBgxmpCy2Z5IEBJyegbNBgRupCSyZ5YMDJCSgbNJi RutCSSR4YcHICygYNZqQutGSSBwacnICyQYMZqYu5JStvOBnHA o8CprCMYcDJCarIZuiSzzuV70kOipR4IdPRF0LF2m7smAlNdWS 7VwuaYW3J4iWlpd5R2JSwrgADTk5QXjbiHYxODRr756MbQltc7 0ZZCtPQBS/F9ja56ciJ90A6bTd2zAjIjqwHcHq0/LVe72JtyZPeZ6mXiymksK4MA05OUFw274rjHPT7734J7df1wof nldrabzZ9U+yD2ja9Y2YgdmQ9gGtarmTKxpa8qO4dw+W/+VWHKKxLw4BHWCvtlQpHLgrLZqna3vmuxnp2+l536GSZCtde/0YqtXIf/O82HNlaNXgdORJA70DpOn3L2JLXMD77sehBDp6wLg4DrjOOQ9/142voun4cp7OwobtQDfkIK0t2wq15nzZqHf/Y84ah2zil0PZBbZvaMTvwOnIkgP7YxWX6k7Ulr4F8dl384PFzs IS12W3bByvgqDhl5OJ62Elx2ShztRJJCFxx+dppEtT+PV1bmy+ mtYVQB2JH1gI4BW+N2UU6lL0lh7IvFEgkYaVGrna1a0FuSAFHY 1L8ZQ7kM1JeNkrwl9OC6Iwh2e0iOVQcWcz+ijWWbRM7FtlyfiA 7sgygEzxp2Gqg5Icm8TxKDUt2PblYQICEJaZwTh3P6426rBSCK 08wigIKOBhOIuWRFVwejTGQzTvEYop0OujvNcKzMpHCxHmu0lg aQmTG0saxQtEDdMyOHATQv1HHi5oaKPmhWTyPUsWSw1leJQAR1 tj34ZGcdu6r3HixXm70Dtzf37rrgxRzkIDDMU/h9f6hXaMEyaMxBrLxJk9PaBapNHLXiB1IxxxZGSv3/p4+4h3bseiWs4PZkYMALsEb+64f3SMoNVDyQ7t4HqWOJRuM5GE IaynD838ez75/390+dEIx05WRICrKxZLk+pXACDgebt9/LtXDO6CHyqMxFrJxJk/PaDbtoVxsknfixF1VHTX1Po1cg07u2H0HroMALsVzjmIwqMGB6 8Ns9oiPwRCWHHxeZ7XNVbr3xjWVWyDjTOtDHONhBLwGcvp07H6 WFvJojIVsxPOJtHHpEHklKdzMocOooHG07faOlQa0I3sB1DsYn LueQsbf5hnXpR7atYAhLGGwz37o45Ycw7tjDFSJGAGvgH+ofei QCjGPxljIRik2ikurrcTIte/Q+1MmL37qbXfsWGFAO7IXQLWXXaT/yPgbvXai9MNJUYQlxi3F7XT9u6SrF5tjxd5ZH0WIKAG3xh+RDO 8mWC/QeFMInJm1aHk0xkQ2SrFJPOLSaxdM1D7ryP4+pNru2rGSoHZkP 4lzD+qGq93OUM2SSwO//8XHCYyBD3gh/AHO4PD9QvktxF1lgwszUhdacg02bj9sEuiAFyQ1Un2l/BbirrLBhRmpCy3ZGvVFMxcANuCliXsyHXmb28oGFmakLrRkS0y eW1YJyIBbIW35Wsktx61lAwkzUhdaMskDA05OQNmgwYzUhZZM8 sCAkxNQNmgwI3WhJZM8MODkBJQNGsxIXWjJJA8MODkBZYMGM1K XlCUTQgghxJKoJZc+HChK6/vfHAw4OQFlgwYzUhdaMskDA05OQNmgwYzUhZZM8sCAkxNQNmgw I3WhJZM8MODkBJQNGsxIXWjJJA8MODkBZYMGM1KXepZc+O2MFJ YxDDg5gb1shi5Zd/w3e70Zx9FbQWxg802N+bawPLu1VPVkR65LNUsu/W5CCssYBpycoLBsxNuHx/7pvri8G3w3VF8KM3TBG7FD79z001xbGPRXqWcFtSNXf5G0EdUs 2X/ze35QhXVZGPAIa5W/RUU5SFnZvGPvHPn7L34J7dc16SVdypu+glOJLT/NuoXi7zMB7cgilVelliVPXaNckQIV1nVhwHXGcei7fnwNXdeP4 1T1h47+/KakbOQYb8yR19Pm97rOCYPSJEjdlp/m3YL7W4oYFGRHLj5cj0MlS140VizCWMIausuLCSvgqFie7jSBi SU7dqeZsjZqHf84TNyOvp1/C4qv5wKyI2upvCh1LNkR2B0mKZw9xGuqfiMFHI3iY0LtYnPo73 SfRKcKfG/52mkiU7jraDvrFgoXBNCOrE27uyQ1LNlX1/WP9cSw0xQAT1xScZFBtile87cwZR4o4GAkD0Dh8mhMYdkoB0Nz +VEi7lcmeQlaaaL4qTZ9K98W7notWY1gNFA7PlRXA6CCJS9F6F ny8gCIsMa+f/+61XK1w3TlYtF6udErFO9v3fVBZAUScDjmKUPeP7QxUZA8GlNa Nu8Ie7Gd+lMi3u813LoU88PQT92+6q+cawvFZQLbkYPfrwZq54 fxINfH2pLXWDjeVEJlGMJayvD8n8ez79/TMoZulcN62qxM9HBD5n+kr18JjIDj4fb+Zz+K23DQ8mhMadl4k 6cnNr1NmrY2sPVK+2mwdrEt5Aa2I/upVAO188NEkOtjbMnrWYEfmfzVCENYcvD52XXeRaFn33vjmsoN E3Gm9SE0hRHwGsjp07GJvS3k0ZjislHuttRs2kOZ/KHeg6NfBY6MiBbaQnZwO7JMJQeuPya8jlNu3guGsITBBnf7B5Y c49mPCavG0BVGwCvgd+1Dh1SIeTSmuGycQQnvo6S1yZkdkc0cy FmRLRQAtyPb/P7ayPiXHbgOD3SKRRlFWGLcUsxu698lXb3YHCv2zvooEkUJuDW +ov3z48455PSmEDiHpmh5NMbGkn373VF0xIm03MzRaw0ltlAC3 I5s8/trY23J8qloY/8sEWVcYU1cTV/wAS+Ef0IVnCRfKL+FKC8b5ZEau57NGFyPCOvU8av/+bdQBOCOXPi9CBhYW7IZ0PufuA+jWaADXpDUSPWV8luIu8oGF2 akLrRka9SH410A2ICXJu7JdORtbisbWJiRutCSLQmvNNben5xA BtwKacvXSm45bi0bSJiRutCSSR4YcHICygYNZqQutGSSBwacnI CyQYMZqQstmeSBAScnoGzQYEbqQksmeWDAyQkoGzSYkbqkLJkQ QgghlkQtufThQFFa3//mYMDJCSgbNJiRutCSSR4YcHICygYNZqQutGSSBwacnICyQYMZq QstmeSBAScnoGzQYEbqQksmeWDAyQkoGzSYkbpUsmT5PtLcUFj GMODkBLVkM3TJ2qMVqHEcvRXEBo6/2ml32/IFcwGwI8+RX55bG4ThUm+IqmLJFm9eABTW6/XaLAXtghpwAC5VMTJjIhvxMkbnjclj/3x0g++JaoEauuC92KGDbjpy4p2Qblu5mumravA68jvYg/4a+cWor/KSlwqW7PaBcoHEE9YrfN39tYAMeH2maqoX0l3v7b02FrJ558BJ gf/6l9Du1AKlvO8ryOmmI4vd0NuK1WwK5gJaR3YiH42d9Ol2sbfks X9OsS1qUGjCio+6XAS8gCOQHHB0ztVuS3nZyH4Xc+T1tFkUKKV JkLgtR051f6etXM2oYC6AdeTYiMX87zF28twq9pYciPumlvyOw hUUNIMXcATmpMs6/Pbjrru5KxtashNmzZS1Uev4x8rlzPSxtrYbSlu5mlHBXIDryKl khcMXF+hK1S35RteSvTOmsX8+nt3QvIAWAANuj7hq7FuyP1A99 n0/DP1VJxfsw0I2ylBFYjQ0VqCcJmlXPbAbWttwNaOCuYDXkcOLBm 4IpuCtqzTfm+wtOQjwjSw5fsa0k7lzQh4KAgbcHDmy6OZ8+nfz NSMrJrKZOo4yJ0jrS9ECpWzG+UY5bdZnaSmfem3D1WwK5gJiR4 7OyHCCJ494tDl4yofqavWoYMkzb6XdyJKFsIZerQfejRfreZV7 tAykoBnEgNszDOsA5LMfPUtWK7KmgTthIxvlOtH2PF1ZoGLOEL qqa6KyvTQExc2VPStbMBcgO7IekvUy+/I/b0ZAmAL5YSxTFaluyaXcBVFY/mmS2sMC6QU3azyWQRo8T0YMeD3m8+VgZGTo/JQbVVlgbGSjTVbenM4hC1RknCPlyEq6vT+pjXhHplYb3ewD2ZH 1yC/BG/uuH93upKZAfmg8ALGL+pZcKBKQwnIHNtWHETgKeT7FXRfz+vNd EVBABtyK4BqyMyoq56Yos4zgkmmHkWyUycqb9xQpBUq9j0m/jhwdNfU+jbeNWnJpuWB2ZC3yywHuHMXgCJcD10cpWpAgheUNtO gHvUsJj1myqOsgQAbcCFlYl6N6eT+r4t142TTDSDbK/WbbIxSyQEU2szt/QftY28jdcTZHcJgdWQuJfjNb652ppiUXvfcdU1jB2VQ4jvl6vd Yy/QyKunPKhag6zICboB9m+4fumiEvq934NNnSkpWjpnRPEgVKbub YVSR58VNtq+ytvj8lwOzIWkiUx7dg1sZDVLXk1+s1dLeyZB91f KrVJ3y1EPBCqFcld1ptq+nOhZVslIea7np2WlCggtmXh+d1uLu RaBt/BGuxgrkA2pHDyM8fTge68dnwrVHbkouBvv/qhaFlJMa9jbWRJySjB7wg6tG6OCWW2bz489x2cWPZgMKM1IWWX AHtGXFeWRcT9Bs4+EMOeGl0T9YuXS5fmL5JAJg7ywYTZqQutGR j/CkJwezrZvxXATXgVhx4yNIV0p2Lu8sGD2akLrRkkgcGnJyAskG DGakLLZnkgQEnJ6Bs0GBG6kJLJnlgwMkJKBs0mJG60JJJHhhwc gLKBg1mpC60ZJIHBpycgLJBgxmpS8qSCSGEEGJJ1JJLHw4UpfX 9bw4GnJyAskGDGakLLZnkgQEnJ6Bs0GBG6kJLJnlgwMkJKBs0m JG60JJJHhhwcgLKBg1mpC60ZJIHBpycgLJBgxmpCy2Z5IEBJye oIpuhS77pY34GubvSOI7eCmIDR1/TGGu7sW/lAe7I13kDYwJLS971ftJcoAqreo8rBWrAAWjk9ZpVKC8bUXbG/jmX9bF/Proh9MT1bpQlbUPnOIH3H2ejyeqWqH5O2419syihoB3Zf9vahf uToSW/pW4VS0hhXfl99ZABr89U4HXZmx6kYlJcNqLsBK/sCqq8a4QPzyi1tRc2HTlR/Zy26X2zKaGQHXno1h/+yXhEA5hZsvXr2vGEdfEX1uMFHAFtDHTBOSW6LYVlIztdzPXWU 9P3us7hs9IkyNqWS6T6/g5HdvatfAEB7MhrVlaG/qIdx96SjUoQnrC8HvXufFcqx3gBR2BOuqyibz/uupu7spUlOzHWjE8btY5/LOyh2/DJRPXz26b2zaiEAnZkf6hpisNVe42ZJW+cMGQHV1jvAIz98/HshuuoCjDg9oirxr4l+wPVY9/3w9BfdXLBPorLRik7zjh0GPvAEpevnSZbrrp7N9S2iX0zKqGAH Vm5cHDVwUbb6V3afDltpkQWgIV1Wktzj4Q8PgQMuDlyroCb8+n fVy0l5ygvG6XszFlROlJ0FlF8tq/iyEpZ09vLtol9s5lyjNmRhSsHqREhkR/uXK02lpYcjta6Uc5epxCFFU710S6HjP0zOGjWBs+wRPR6vTADb s8wTMmbEudaslpPL3tJbCcGslEuEm2Pfb7XcLtibKJe4jxXaS9 dItxgct8MLniBduTI8IEabfnhztUQMLVkbxZj4VntiMLyT5Nkp 3/pRy3e5I5uAJ1xiBjweszny8HIiDtx9PWKaOBWGMjGLztvNq1NG mNkkCPlyEquxRhhbHha3zftt2QGsiPHprap0ZYf7lwNAlNLVgb 27jRw7f9+9XkEjkieT+X6yerJMAqagQy4FcE1ZGfwUc7XUSYaw SXTDgvZKPceblqb4gHqLUhxV1XHSL1PI9egk/tW/j5KxI6cHrDnwPV5DO/6QBSWP5lfH6BaSnjMkkVdBwEy4EZErwh2g5yZong3XjbNsJCNU na2hyfk4VJkM7uTF7SPtk3uW/kSCtiRbR9pUZkKlnzbGdcvcTYVjmO+Xq+1TD+Dou6cciGWcMyA m6Afac8+vTE+pmrgPphZsnLIlO5G4mRVbubYJSS/fbxtct/Kl1C8jnyvLmJryYaPFsQTlkQdhGr1CV8tBLwQ6sW/nXWk1XTnwkQ2StnZ9eC0oQsnan/gyP5upNom9614CcXryPd6IK2xJduBvv/qfIVl1Nq9jbURQaIHvCDqbZPilFhm8+LPc9vFjWUDCjNSF1pyB bQH23tlXUzcb+A0CjngpdE9Wbt6uXyhvtzghtxZNpgwI3WhJRv jz8BVn23bgP8qoAbcithznzZXbTPdubi7bPBgRupCSyZ5YMDJC SgbNJiRutCSSR4YcHICygYNZqQutGSSBwacnICyQYMZqQstmeS BAScnoGzQYEbqkrJkQgghhFgSteTShwNFaX3/m4MBJyegbNBgRupCSyZ5YMDJCSgbNJiRutCSSR4YcHICygYNZq QutGSSBwacnICyQYMZqQstmeSBAScnoGzQYEbqQksmeWDAyQns ZTN0yWeKy/ckv17jOHoriA1svhMq3xaKv6sEsyNvBvAyGFuyfO3YrpeknQBT WJsFoV1QAw7ApSvIhxSWjSgvzsuIx/65vNB6Xkl9G4j3Pmzt5dibfpprC4P7fpNCD0eH7MibAbwOtpb8 Frx8HWGBggUrrKuKCTLg9ZlqvK7wUsejDVFWNqK8BC8HCezXNe mloyqv+QqyueWnWbdQ/OAOsCNvB/BCWFqyHHIpOAiDJ6yLvx0XL+AIaMOgC84Z220pKRvZ42KOvJ42 v9d1jp2VJnKgL5nFvFtwf0uRSoLXkbcDeCWqWPIST/lJNvCE5RWIt8quJCy8gCMwJ10Wz7cfd93NXdnEkp0Aa6asjVrH Pw5zOXSbR9n5t1CweiB25I0AXgpLS9bOGZJnEZ8AKCzvt4798/HshuvUYsCA2yPOXHxL9geqx77vh6G/6uSCfZSVjVJeEmPAsVdeO02kDe7w08xbKGxKkB05GcBrYWvJs+ jlUWv2OAMKK37GtJO5ZECKEjDg5si5Am7Op3/f2oEFhWWjlJc5JUov8n1PXoJWmih+qs4+yraFO15Lfr3iAYzGa seHkPPEjC1ZGbAtNISLKKywUw29WhW82y/W8yr3GB5OR5gBt2cYpuRNiXMtWS0qmgbuRGnZKOVlykmiD73Xk NNQpR+Gfuqaur9yri0U7/qoHVkJoBqrnR/G41wZa0v25jJGPskCorD80yTZ71+i2wW3bLzX37xhogqIAa/HfL4cjIwM3UMZRYWqCMaUlo1WXja9TZp2ZIQj5afB2sW2kBvUj ix/vhqrnR8m4lwZa0tWxvbK3BkEKSz3p6qPJHB08nyKif/z+vO9GlBABtyK4BqyMzYq5+Uoc43gkmlHcdko5WXzLEC5OUK9W 1O/ChwZDi20hezAdmT953Pg+lPkjR9lbgWBFNZ6l8VLOxR/vZzh6Zgli7oOAmTAjZCFdTmkl7dUKt6Nl00zistGKS/bYxPyWCmymQOZK7KFAsB25JvcM1jHkuV4zB1mXL/E2VQ4jvl6vdYy/QyKunPKhahLzICboB9szz69MUSmauA+2FiycryU7kPiRFqvW0c 6YoktlAC2I9v8/OqYW7Jyh3uRe95hheWgDtm3+oSvFgJeCPXa5E6rbTXduSgvG6W 87Hpq2tCFc14+8tMSWygCbkc2+fnVsbdkI9D3X32W1zJq7d7G2 sgTktEDXhDleX/KKbHM5sWf57aLG8sGFGakLrTkCmjPx/PKupim38BpFHLAS6N7snYBc/lCfUbiDbmzbDBhRupCSzbGn4EbzL5uxn8VUANuRezRT5urtpnu XNxdNngwI3WhJZM8MODkBJQNGsxIXWjJJA8MODkBZYMGM1IXWj LJAwNOTkDZoMGM1IWWTPLAgJMTUDZoMCN1oSWTPDDg5ASUDRrM SF1SlkwIIYQQS6KWXPpwoCit739zMODkBJQNGsxIXWjJJA8MOD kBZYMGM1IXWjLJAwNOTkDZoMGM1IWWTPLAgJMTUDZoMCN1oSWT PDDg5ASUDRrMSF0qW/I4Os/3zfrKIwrLGAacnMBeNkOXrDLzA8jdlTbL1OZ7Fj/agvJSQm97eWFHroulJcu3lHrvftdfBH8WVGFtFIR2QQ04AI28X rMKhWUjas7YP+cyM/bPRzf4bqi+oGuzTG068qEthPvs7LLzQTFFsSPXxdCS32p3lKS8 0u7iZ8lXfl89ZMDrM9V4XdjyIPV2lJWNqDnB+7qCwuOa9NJRt8 vUliMf20Jsn4PXuBYTDjtyXcwsWb6uXekdGWWGJ6yLv7AeL+AI aMOgC+L054aUlM2umuMUnvXs0zl23i5TW458aAuJfQ72p1QZYU eui70lO2oMtZpTZHjC8jrb+6dfqRzjBRyBOelS2m8/7rqbu7KJJSdqjvt18F3k4zCXQ7dZuQ5sQdln96P1hJtnyRfFzJ LVEwZnRCe3wgCF5QVg7J+PZzdcpxYDBtwecdXYt2R/oHrs+34Y+qtOLthHWdmka04Y+MA5l6+TZWqHIx/bQmKf30dw2q5nhB25LoaWPGvN06T2WRYAhRU/Y9rJ3Fkhz6oAA26OnCvg5nz6960dWFBYNkp9WfxN9iL/oq+0SaWJ4sjqPNUDW0jUycixRFaa78h55wmbY2nJ6mhtcvrLBy AKK/ytQ69WBe/2i/W8yu2VgIpDDLg9w7AOQD770bNktSprGrgTpWWj1Jzt+VHvNdx+ GCtToZ+6pu6vvHcL+j67vb9w52+6I8fj3wymluxNZPQ+u4cl+7 9V9vuX6I3BLRvv9TdvuagCYsDrMZ8vByMjQ/dQRiQbrR1ZKC0breZsTuSQph0pUylHDtbeuYXYPoezvMrRckdO xL8ZTC1ZvQlIzPnPA6Sw3N+vPpLAUdTzKe6cmNef79WAAjLgVg TXkJ2xUTmdSJlrBJdMO4rLRqk5quW9xApeYtQypV9HjgycHtyC 2ESxa3wBzXdkDlwfQLvro9CdIJDC8u7x18fP1oPhiCXbHCofBz LgRsjCupwTyXtSFe/Gy6YZxWWj1JftsQl5rBTZzIHMHdiCWhM3DyQyceeOjEAFS1buk i9wmoAprOBsKhzHfL1ea5l+BkXdOeVCLOGYATdBPyyffXpjME3 VwH2wsWTleCndh4T/yc0cvX50YAt6TSz70K6FG3dkCGwtOfZ01wI6a0FY8fEpRM/doIWAF0K9NrnTaltNdy7Ky0apObuemjZ04UTtjxz50Bb0R7DaP Jj1xh0ZAmNLtgN9/9VneQVP5nlXjkaekIwe8IIoD0xUTollNi/+PLdd3Fg2oDAjdaElV0B7tr1X1tcn7j5wR6oDkANeGt2T1VsL5 i/U9xvckDvLBhNmpC60ZGP8GbjB7Otm/FcBNeBWxB79tLlqm+nOxd1lgwczUhdaMskDA05OQNmgwYzUhZZ M8sCAkxNQNmgwI3WhJZM8MODkBJQNGsxIXWjJJA8MODkBZYMGM 1KXlCUTQgghxBLdkgkhhBBSF1oyIYQQAgEtmRBCCIGAlkwIIYR AQEsmhBBCIKAlE0IIIRD8H2LdwRZBghXvAAAAAElFTkSuQmCC

benyaminrahimi
چهارشنبه 25 اردیبهشت 1392, 19:51 عصر
select * from t where mande>0
:))))

محمد سلیم آبادی
چهارشنبه 25 اردیبهشت 1392, 20:07 عصر
اگر مطلب را درست گرفته باشم.
به ازای هر فردی چند مانده وجود داره که باید مقدار آخرین مانده هر مشتری بررسی بشه که آیا صفر هست یا نه.
برای این منظور داریم:

SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY user_name ORDER BY date DESC) AS rnk FROM table_name)d
WHERE rnk = 1 AND mande > 0

tooraj_azizi_1035
چهارشنبه 25 اردیبهشت 1392, 21:16 عصر
SELECT LastName, MIN(Credit) as "Current Credit" FROM Account
GROUP BY LastName
HAVING MIN(Credit) > 0;