我想选择在IE7上运行而不在IE8上运行的测试.我试过这个,但我得到0,这不是真的.
SELECT test_name FROM tests WHERE version='ie7' AND NOT EXISTS (SELECT test_name FROM tests where version='ie8');
谢谢！
解决方法
试试这个
SELECT test_name FROM tests WHERE version='ie7' AND test_name NOT In (SELECT test_name FROM tests where version='ie8');
