ÎÒÏëÏȲéѯ³ö·Ö¾í£¬È»ºóÿ¸ö·Ö¾íÖж¼ÏÔʾ×îеÄÒ»¸öÕ½ڣ¬ÓÃÒ»¾äsqlÓï¾äÔõôʵÏÖ£¿ SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid ÓÃleft join Äܲ»ÄÜʵÏÖ½µÐòµÄ£¿µ±È»¿ÉÒÔ£¬Ö±½Ó¸úÉÏ ORDER BY volid DESC//»»³ÉÄãÏëÒªµÄ¾ÍÊÇ£¬Ò»ÑùµÄ°¡
SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid ORDER BY s.dateline WHERE v.volid>2 DESC ORDER BY v.dateline DESC
ÕâÑù£¿ ÕâÑù±¨´íµÄ
SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid ORDER BY s.dateline DESC WHERE v.volid>2 ORDER BY v.dateline DESC
ÕâÑù£¿ ÕâÑù±¨´íµÄ SQL code: SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid WHERE v.volid>2 ORDER BY v.dateline DESC
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......