SQL语句:DELETE*FROM参赛选手WHERE姓名=‘陈远志’,其功能是？

没有任何区别，加上FROM更规一些。deletefromSheet1wheresheet1.to_mobilein(selectto_mobilefromSheet2)与deleteSheet1wheresheet1.to_mobilein(selectto_mobilefromSheet2)以及deletefromSheet1和deleteSheet1都是相同的。可以在企业管理器中运行一下，如果不加入FROM，系统会自动加上的。扩展资料：数据修改是添加、删除或更改信息的意思。使用INSERT、DELETE和UPDATE之类的Transact-SQL语句在数据库中添加、删除或更改信息的操作。在SQL语句中，INSERT、DELETE和UPDATE操作的对象是数据库表中的数据，也被称作数据操纵语言(DML)。INSERT语句语法：INSERTINTO表名（列名1，列名2...）VALUES(值1，值2...)DELETE语句语法：DELETEFROM表名WHERE选出符合要求的记录UPDATE语句语法：UPDATE表名SET列名=值1WHERE选出符合要求的记录

恩 这个效果是一样的 后者是对前者的一个简化 只是SQL sever中的语言和 标准SQL的区别而以 用哪个都没有影响

在SQL Server中两者没有区别，但在Oracle的SQL语句中，delete * from是不标准的语法，执行无法通过。 Oracle下执行delete from语句（成功）： Oracle下执行delete * from语句（失败）：

delete from作为一个整体使用，中间是不可以接任何东西的！格式是：delete from 表 where 条件

在SQL Server中两者没有区别，但在Oracle的SQL语句中，delete * from是不标准的语法，执行无法通过。Oracle下执行delete from语句（成功）：Oracle下执行delete * from语句（失败）：

在SQL Server中两者没有区别，但在Oracle的SQL语句中，delete * from是不标准的语法，执行无法通过。Oracle下执行delete from语句（成功）：Oracle下执行delete * from语句（失败）：

从买家中删除。delete表示删去，删除，from表示从…起，buyers表示买家，deletefrombuyers语句表明从买家中删除。

删除数据，deletefrombook语句的作用是删除数据。如果删除图书id为1的图书信息，其SQL语句为：deletefrombookwhereid=1。在实际开发中删除数据通常使用PreparedStatement对象进行操作。

您好，可以参考一下http://www.cnblogs.com/dudu/archive/2011/10/15/2213462.html

在SQL Server中两者没有区别，但在Oracle的SQL语句中，delete * from是不标准的语法，执行无法通过。Oracle下执行delete from语句（成功）：Oracle下执行delete * from语句（失败）：

delete SQL语句：1、DELETE FROM <table/view> WHERE <condition>，用于删除表中的某行或整个数据表中的数据。2、DELETE FROM table_name，用于删除所有行。可以在不删除表的情况下删除所有的行。这意味着表的结构、属性和索引都是完整。3、DELETE FROM Person WHERE LastName = "Wilson"，用于删除某个行列。扩展资料一、delete sql应用：1、对于删除整个表的所有数据时，delete并不会释放表所占用的空间。2、如果用户确定是删除整表的所有数据，那么使用 truncate table 速度更快。二、delete应用实例：1、delete from gem_file where gem01 = "2BSB"；—where还可以用子查询作为condition。2、作用：删除部门编号为"2BSB"的部门信息。

delete学号from学生表含义是删除Student中的全部记录。根据查询信息相关显示，deletefrom学生信息表就是删除学生信息表中的全部记录。

delete是删除表数据；drop是把表本身从数据库种删除

您好，很高兴能够为您解答! * 表示每一列，而delete的时候是整行的所有列一起删除的，不可能只删除某几列； delete from table where del=1是标准答案 在oracle中，from可以省略，但是在mysql中from不能省略 希望我的回答能够帮到您!

ASP与SQL数据库连接语句具体如下：Setconn=Server.("ADODB.Connection")connstr="provider=Sqloledb;server=服务器名;uid=用户名;pwd=密码;database=数据库名"conn.OpenconnstrIfErrThenerr.ClearSetconn=NothingResponse.Write"数据库连接出错，请检查连接字串"Response.End扩展资料：SQL常用命令使用方法：(1)数据记录筛选：sql="select*from数据表where字段名=字段值orderby字段名"sql="select*from数据表where字段名like‘%字段值%‘orderby字段名"sql="selecttop10*from数据表where字段名orderby字段名"sql="select*from数据表where字段名in(‘值1‘,‘值2‘,‘值3‘)"sql="select*from数据表where字段名between值1and值2"(2)更新数据记录：sql="update数据表set字段名=字段值where条件表达式"sql="update数据表set字段1=值1,字段2=值2字段n=值nwhere条件表达式"(3)删除数据记录：sql="deletefrom数据表where条件表达式"sql="deletefrom数据表"(将数据表所有记录删除)

S表中年龄大于10岁的记录被加上删除标记。S表中年龄大于10岁的记录被加上删除标记。DELETE是为表中指定的元组添加删除标记 DELETEFROMTableName[WHERECondition]其中，FROM指定从哪个表中删除数据；WHERE指定被删除的元组所要满足的条件，若省略WHERE短语，则删除该表中全部元组。该命令是逻辑删除，如果要物理删除，需要继续使用PACK命令。

delete from A where ID in (1,2,3) and ID not in(select ID from B) 或delete from Awhere not exists (select ID from B where ID=A.ID) and ID in (1,2,3)

DELETE FROM table WHERE Id >= 4

DELETE FROM 表名 WHERE 字段=‘删除条件"

drop table 可以理解成，把这个表整个从数据库里删掉，也就是说你在select * from table 就搜索不到这个表了，delete from table 是将表内数据删掉，可以理解成清空表，清空之后再查询 是能查到表的

首先创建连接就创建个Cnnection对象，然后把驱动加上，还有帐号密码什么的！我没连过sql数据库，不知道驱动，你可以在网上搜一下。给你一个我连接mysql数据库的例子publicConnectionGetdata(){//这是连接数据库的一个方法，还可以配置连接池。Connectioncon=null;try{Class.forName("com.mysql.jdbc.Driver");//加驱动con=.("jdbc:mysql://localhost:3306/data","root","qq");//数据库路径、端口、库名、数据库用户名和密码}catch(e){e.();}catch(e){e.();}returncon;}publicvoiddelete(intid){//对数据库进行操作的方法，先调用上面写好的连接！Connectioncon=Getdata();Statementst;try{st=con.();st.("deletefromkaoshiwhereid="id);}catch(e){//TODOAuto-generatedcatchblocke.();}}

我从头跟你说起吧，保证具体：增、删、改、查 分别对应的四个关键字是：INSERT（插入），DELETE，UPDATE，SELECT，这个题是删除记录，所以要用到删除的关键字：DELETEDELETE的语法是：DELETE FROM table_name WHERE 条件DELETE 后面不跟列名，我再说说其它的几个语法吧：INSERT 一般我们都用：INSERT INTO table_name(列名） VALUES（值）值要跟列名相对应。表名后面也可以直接写上VALUES ，这样就是说不加列名，插入的时候就是按表中列的顺序依次插入UPDATE 语法是：UPDATE table_name SET 列名=值，SET.... WHERE 条件SET 中间一定是逗号，AND 等都会错误SELECT 就麻烦了，先不说了，现在说一下这个题目：我们假设四列为：产品编号：ID，名称：proname,价格:price 库存量：count由于是删除，所以要用DELETE我们就要想到：DELETE 后面不能跟列名，直接跟FROM 表名，然后是WHERE 条件这里主要是WHERE 后面的条件：其实也很简单：价格打9折：就是 price*0.9打9折后还要小于50，就是price*0.9(打9折后的价格)<50所以这个题的语句就是：DELETE FROM product WHERE price*0.9<50

mysql有两种方式可以清空表。分别为：deletefrom表名和truncatetable表名。1.deletefrom表名，删除表数据，全部删除则是可以清空表，相当于一条条删除，需要注意的是，如果有字段是自增的（一般为id)，这样删除后，id值还是存在的。举例来说，就是加入你在删除之前最大的id为100，你用这种方式清空表后，新插入一条数据其id为101，而不是1。2.truncatetable表名，直接清空表，相当于重建表，保持了原表的结构，id也会清空。相当于保留mysql表的结构，重新创建了这个表，所有的状态都相当于新表。效率上truncate比delete快，但truncate删除后不记录mysql日志，不可以恢复数据。

Delete from device是永久删除，在本手机上再也找不到；Move to Bin是放垃圾箱中，在本手机上的垃圾箱中可以看到已删除的内容。手机中的垃圾箱一般有时间限制，过一段时间会自动永久删除

您好，很高兴能够为您解答!* 表示每一列，而delete的时候是整行的所有列一起删除的，不可能只删除某几列；delete from table where del=1是标准答案在oracle中，from可以省略，但是在mysql中from不能省略希望我的回答能够帮到您!

这相当于一个始终成立的条件语句因为 1=1始终成立所以无论如何都会执行

delete是删除整行的语句，你的意思应该是清掉a字段的值吧？asp中用你的连接对象执行update就行，如：obj_conn.execute("update table set a="" where ID="" & id & """)

给准备删除的记录加上删除标志可以是单独一个delete，针对当前记录也可以是delete next 10，针对此后10条记录也可以是delete all，针对所有记录也可以是delete for 性别="男"，针对所有“性别”字段值是“男”的记录

sql中baidelete语句不能删除表,只能删除表中的所有行数据。from-树懒学堂-免费数据知识学习平台

应该是你的缓存机制导致的，可以在网址后在添加一个随机参数来解决。

1、sql中使用DELETE 语句删除表中的行。按条件删除数据的基本语法是“DELETE FROM 表名称 WHERE 列名称 = 值”，这里以学生表举列，学生有姓名(name)和年龄(age)两列：2、首先需要查询张三的数据，输入sql语句“SELECT * FROM student WHERE `name` = "张三"”，即可查询到张三的数据：3、然后输入删除学生张三数据的sql语句“DELETE FROM student WHERE `name` = "张三"就删除成功了：

delete SQL语句：1、DELETE FROM <table/view> WHERE <condition>，用于删除表中的某行或整个数据表中的数据。2、DELETE FROM table_name，用于删除所有行。可以在不删除表的情况下删除所有的行。这意味着表的结构、属性和索引都是完整。3、DELETE FROM Person WHERE LastName = "Wilson"，用于删除某个行列。C++中的Deletenew/ delete 的使用（仅限于c++，注意，new、delete不是函数而是操作符！注意与c中的malloc和free区分）编程的时候经常要用到堆内存的分配，通常使用的操作符是new，这个时候就必然要用到delete去释放申请的内存空间。此时至少要遵循以下原则：（1）new和delete是成对出现的。只出现一个是错误的或不规范的写法，即使能编译通过，也会有安全隐患；（2）使用的new与delete要相同。也就是说如果你在 new表达式中使用了 []，必须在对应的delete 表达式中使用 []。如果在new 表达式中没有使用 []，你也不必在对应的 delete 表达式中使用 []。

SQL语句

C.........................................

delete from book where 1=1 + and 条件Google “Java 动态查询”

【答案】：D【解析】删除数据的命令格式为：DELETEFROM表名[WHERE条件]，WHERE指定被删除的记录所满足的条件，因此选D。

不想要ID从1开始: delete table name想要ID从1开始: truncate table name

把你的SQL语句打印出来，放到数据库执行一下看行不行。【where sid="+a+"and cid="+b】，and前面是不是少了个空格。

rs.open sql,conn,1,3 修改成conn.execute sql看看可不可以

delete from temp_5 a where exists (select 1 from temp_3 b where a.id5=b.id3)

你写的那条是因为2没有打引号。这个方法中studentBean.getStuID() 的值是什么啊？里面没东西啊 。

用来从数据库表中删除记录的SQL命令是（）。DELETESELECTUPDATEWHERE

delete from 表名 执行delete后，表结构依然存在，只删除表中全部数据。drop from 表名 执行delete后，表结构和数据全部被删除。并且delete执行后还有个提交的过程，drop就一步操作完成。

delete应该没commit不作数啊....及时回滚应该就可以吧- -..除非你已经commit上去了/./

直接DELETE TOP (5) FROM student

delete from table where DATE_FORMAT(date, "%Y%m%d %H%i%s") = "2012-10-22 00:00:01";

你写的没错啊，如果报错，可能是你的表中没有id为1的那条数据，或者数据库没有这个表。仔细看看吧

在平时的学习、工作或生活中，许多人都有过写作文的经历，对作文都不陌生吧，作文一定要做到主题集中，围绕同一主题作深入阐述，切忌东拉西扯，主题涣散甚至无主题。写起作文来就毫无头绪？下面是我整理的缓解压力的英语作文，希望对大家有所帮助。 缓解压力的英语作文 篇1 As the pace of modern life continues to quicken, many people are in the habit of rushing through life. Some admit that stress seems to be on the increase all the time. A certain degree of stress is beneficial to us, but too much stress is certainly harmful, and sometimes may even harmful to our health and physique. So it is necessary to know how to reduce stress. 随着现代生活的节奏不断加快，许多人的一生都活在匆忙的习惯中。一些人承认压力似乎一直在增加。一定程度的压力对我们是有利的，但是过多的压力肯定是有害的，有时甚至可能损害我们的身体健康和体质。因此有必要知道如何减轻压力。 缓解压力的英语作文 篇2 There are many ways that can help us solve this problem, but the following may be the most effective. First, learn to come to terms with yourselves. Dont set a goal that is too high because there are many things in this world that are beyond your reach. Learn to be content to go as far as you can. Second, learn to come to terms with the world around you. Dont try to change other people or other things. There are people and things in this world that you can do nothing about. So learn to accept them. Third, dont be too interested in material things and dont try to "keep up with the Joneses." Dont harbor any jealousy, vanity or resentment to others. Be satisfied with what you have. Finally, keep in touch with your friends. Talk with them, share with them your happiness and misery. This will help to make you feel better. 有很多方法可以帮助我们解决这个问题，但下面的可能是最有效的。第一，学习接受自己。不要设定太高的目标，因为在这个世界上有很多事情是超出你的能力范围的。学会尽量满足自己。第二，学习适应你周围的世界。不要试途去改变其他人或其他东西。这个世界上的有些人和有些事是你无法改变的。所以要学会接受他们。第三，不要过于关注物质的东西，不要试图攀比。“不要怀有任何嫉妒，虚荣，或者怨恨之心。满足于你所拥有的。最后，和你的朋友保持联系。与他们谈话，与他们分享你的`快乐和痛苦。这将有助于使你感觉更好。 缓解压力的英语作文 篇3 It is true that people in modern times experience great stress in their lives. However, as to the ways to cope with the stress, different people have different opinions. Some insist on traveling, while others argue for listening to the music or even playing computer games. In my opinion, an effective solution to relieve pressure is to do physical exercise. My suggestion lies in the following reasons. First of all, exercise not only helps to release peoples emotional breakdowns but also improves their mental state. By concentrating on their body movement, men forget about their annoyances and escape from the busy day. Whats more, physical exercise moulds peoples character and promotes a more optimistic attitude towards life. Besides, physical exercise conduces to sound health, with which people can face up to the stress and difficulties in life more readily and easily. In a word, physical exercise plays a positive role in killing stress. I believe that my own experience is also applicable to others. Therefore, I suggest that people should go jogging or do other forms of sport when they feel pressed. 翻译： 的确,在现代经验的人在他们的生活中产生巨大的压力。然而,随着方法来应对压力,不同的人有不同的观点。一些坚持旅行,而另一些人认为听音乐或者玩电脑游戏。在我看来,一个有效的解决方案是做体育锻炼来缓解压力。 我的建议是以下原因。首先,运动不仅有助于释放人的情绪崩溃,但也提高了他们的精神状态。通过专注于他们的身体运动,男人忘记烦恼和逃离忙碌的一天。更重要的是,体育锻炼塑造人的性格和促进一个更乐观的生活态度。此外,体育锻炼有助于健康,人们可以在生活中面对压力和困难更容易和轻松。 总之,体育锻炼造成压力发挥了积极作用。我相信我自己的经验也适用于其他人。因此,我建议人们应该去跑步或者做其他形式的运动时,他们感到压力。 缓解压力的英语作文 篇4 As our students, we also have to face with much pressure, such as the study pressure, exam pressure,relationship pressure and so on. But how can we cope with pressure? This is the most important. Firstly, we should face the pressure appropriately. Pressure is inevitable in our daily life, so we can"t be afraid of them and try our best to cope with them. Secondly, tell our pressure to others. Talking is a very effective way to ease pressure, and during the talking, we may get some suggestions and solutions. Finally, trust ourselves. We should believe ourselves that we can deal with any troubles by ourselves or by others" help. 翻译： 作为我们的学生,我们也必须面对很多压力,比如学习压力,考试压力,感情压力等等。但是我们如何应付压力?这是最重要的。 首先,我们应该适当地面对压力。在我们的日常生活中压力是不可避免的,所以我们不能害怕他们,尽力应付他们。其次,告诉我们别人的压力。说话是一种非常有效的方法来缓解压力,在说话,我们可以得到一些建议和解决方案。最后,相信自己。我们应该相信自己,我们可以处理任何问题由自己或他人的帮助。 缓解压力的英语作文 篇5 Stress is an inevitable part in our normal life. many kinds of things, such as natural disasters, war and death can cause too much stress in our life. but according to a psychologist, on a day to day basis, stress may result from the small things: taking an exam, waiting in line, and having too many things to do in a limited time. we all need stress to add flavor, challenge, and opportunity to life, but too much stress can seriously affect our physical and mental well being, it reduces the body`s immunity and harms the brain, if the stress lasts a long time, it may cause physical illness, insomnia, headaches, backaches, ulcers, high blood pressure even heart disease. when stress does occur, it`s important to recognize and deal with it. there ore some methods we can try. a large number of physical activities can reduce onxiety. shoring our stress with others can be enormously helpful. making time for fun such os listening to music may be good medicine. sometimes even crying is on efficient way to releose stress. 缓解压力的英语作文 篇6 With the development of society, the competition of the entire society is more and more intense, causing increasing pressure to people. Stress of study, work and life are ubiquitous, but how can we deal with it? Here are some tips that I hope can be useful. Firstly, keep good health. A healthy body is the premise to face presure. It"s the least capacity to cope with stress when a person is sick. Secondly, to accept the pressure. The reason why many people can not cope with stress is that they resist and escape it. Actually, there always is trouble and problems once we chose a path to go, because almost everything worth doing is not so easy. Thirdly, solve the problem, rather than complain about it. Many people complain about the surroundings and don"t think about the solutions when faced with problems. We all know that complaint can do nothing but only let you down. As long as the problem not solved, the pressure is always there. Fourthly, tell others your pressure and get help from them. Lots of pressure can"t be solved by our own and the rational way is talking the pressure to workmates or friends to get help from them. But the premise to do so is that we don"t intend to put pressure to others but to seek help and support to solve problems. Of course, there also are some other ways to cope with stress, such as readjusting goal and expectation, playing games to relax, even shopping or eating. But no matter how, solving the problem that causes stress is the best way. 缓解压力的英语作文 篇7 Hello, boys and girls! Pressure is a serious problem in todays world. Students in our class are under too much pressure. Some students cant get on well with their classmates, while others may worry about their exams. Im always under pressure, too. My parents want me to be the top student in class. So they send me to all kinds of after classes at weekends. Last Monday evening, I had a talk with my mother. I told her I was not lazy. I really felt tired. I needed time to relax. My mother agreed with me at last. So I think a conversation with parents is necessary to solve the problem. Thats all. Thank you!

12月9日上午。“正好遇见你”于正12月9日上午的时候播。《正好遇见你》讲述的是文艺编导鱼在藻，与文物专家陶唐合作录制了一档以文化传承为主题的节目，并因此结缘的故事。

编辑本段作品列表　　全部作品： 　　《敢死队2》The Expendables II ......Church 　　《白昼冷光》The Cold Light of Day......Martin(2012) 　　《环形使者》Looper......Older Joe 　　《月亮升起之王国》Moonrise Kingdom(2012) 　　《赌博回忆录》Lay the Favorite......Dink Heimowitz 　　《凯恩和林奇》Kane& Lynch.......Kane 　　《第44条军规》Catch .44（2011.12.9） 　　《迷局》Setup.......Biggs 　　《粉红镇》Pinkvill......William R.Peers 　　《科比就是黑曼巴》 2011.2.19（七分钟短片） 　　《赤焰战场》……Red （2010.10.15 布鲁斯威利斯电影海报(20张)） 　　《敢死队》……The Expendables （2010.8.13) 　　《Stylo》……Gorillaz Mv(2010) 　　《拍档侦探》……Cop Out（2010）.......Jimmy Monroe 　　《我仍在这里》......Himself((2010) 　　《布鲁诺》……Sacha Baron cohen（2009） 　　《即时发生》……What Just Happened（2008） 　　.《高中校长阴谋事件/暗杀我的高中校长》（Assassination of a High School President）（2008） 　　《未来战警》……The Surrogates(2009） 　　1.《虎胆龙威4：虚拟危机》Live Free or Die Hard AS . John McClane(2007) 　　2.《农民宇航员》The Astronaut Farmer (2007) 　　3.《完美陌生人》Perfect Stranger AS …… Harrison Hill (2007) 　　刑房之恐怖星球/恐怖星球/索女丧尸机关枪 Planet Terror ------- (2007) 　　4.Morgan"s Summit AS …… (attached) (2007) 　　5.《篱笆墙外》Over the Hedge AS …… RJ (voice) (2006) 　　6.《勇闯16街区》16 Blocks AS …… Jack Mosley (2006) 　　7.HBO First Look Over the Hedge: Off the Strip & Onto the Screen AS ... Himself (2006) 　　8.Friday Night with Jonathan Ross Episode #10.13 AS …… Himself (2006) 　　9.Cannes 2006: Crónica de Carlos Boyero AS …… Himself (archive footage) (2006) 　　10.大卫深夜脱口秀Late Show with David Letterman Episode dated 17 May 2006 AS …… Himself (2006) 未来战警截图(18张)　　11.The Early Show Episode dated 22 May 2006 AS …… Himself (2006) 　　12. Al Pacino: An American Cinematheque Tribute AS …… Himself (2006) 　　13.Grand journal de Canal+, Le Episode dated 20 May 2006 AS …… Himself (2006) 　　14.《黑水船运公司》Black Water Transit AS …… Earl Pike (2006) 　　15.《火线对峙》Hostage AS …… Jeff Talley (2005) 　　16.《罪恶之城》Sin City AS …… Hartigan (2005) 　　17.Wildwood Days AS …… Himself (2005) 　　18.Tsunami Aid: A Concert of Hope AS …… Himself (2005) 　　19.《阿尔法狗》Alpha Dog AS …… Sonny Truelove (2005) 　　20.《幸运数字斯莱文》Lucky Number Slevin AS …… Mr. Goodkat (2005) 　　21.Shelter from the Storm: A Concert for the Gulf Coast AS …… Himself (2005) 　　22.《十二罗汉》Ocean"s Twelve AS …… Himself (uncredited) (2004) 　　23.《整十码》The Whole Ten Yards AS …… Jimmy (2004) 　　24."Retrosexual: The 80"s" AS …… Himself (archive footage) (2004) 　　25.Geschichte des erotischen Films, Die AS …… (archive footage) (2004) 　　26.MTV Video Music Awards 2004 AS …… Himself (2004) 　　27."Pulp Fiction" on a Dime: A 10th Anniversary Retrospect AS …… (archive footage) (2004) 　　28.Genius: A Night for Ray Charles AS …… Himself (2004) 　　29.《太阳之泪》Tears of the Sun AS …… Lt. A.K. Waters (2003) 　　30.《原野小兵兵》Rugrats Go Wild! AS …… Spike (voice) (2003) 　　31.《霹雳娇娃2》Charlie"s Angels: Full Throttle AS …… William Rose Bailey (uncredited) (2003) 　　32.Hollywood Celebrates Denzel Washington: An American Cinematheque Tribute AS …… Himself (2003) 　　33.2002 ABC World Stunt Awards AS …… Himself (2002) 　　34.True West AS …… Lee (2002) 　　35.《完美盗贼》Bandits AS …… Joseph "Joe" Blake (2001) 　　36.《哈特之战》Hart"s War AS …… Col. William A. McNamara (2001) 　　37.Grand Champion AS …… CEO (2001) 　　38.《扭转未来》The Kid AS …… Russell Duritz (2000) 　　39.《整九码》The Whole Nine Yards AS …… Jimmy "The Tulip" Tudeski (2000) 　　40.《惊心动魄》Unbreakable AS …… David Dunn (2000) 　　41.2000 Blockbuster Entertainment Awards AS …… Himself (Presenter) (uncredited) (2000) 　　42.Hollywood Salutes Bruce Willis: An American Cinematheque Tribute AS …… Himself (2000) 　　43.Entertainment Tonight Presents: "Moonlighting" Exposed AS …… Himself (2000) 　　44.《我们的故事》The Story of Us AS …… Ben Jordan (1999) 　　45.《灵异第六感》The Sixth Sense AS …… Malcolm Crowe (1999) 　　46.《冠军的早餐》Breakfast of Champions AS …… Dwayne Hoover (1999) 　　47.Franky Goes to Hollywood AS …… Himself (1999) 　　48.《紧急动员》The Siege AS …… Major General William Devereaux (1998) 　　49.《陨石大冲撞》Armageddon AS …… Harry S. Stamper (1998) 　　51.《终极密码战》Mercury Rising AS …… Art Jeffries (1998) 　　52.《狙击职业杀手》The Jackal AS …… The Jackal (1997) 　　53.《第五元素》The Fifth Element AS …… Major Korben Dallas (1997) 　　54.《瘪四与大头蛋》Beavis and Butt-Head Do America AS …… Muddy Grimes (voice) (1996) 　　55.《终极悍将》Last Man Standing AS …… John Smith (1996) 　　56."Bruno the Kid" AS …… Bruno the Kid (voice) (1996) 　　57.《疯狂终结者》Four Rooms AS …… Leo (segment "The Man from Hollywood") (uncredited) (1995) 　　58.《十二猴子》Twelve Monkeys AS …… James Cole (1995) 　　59. A Night to Die for AS …… Himself (1995) 　　60.《大智若愚》Nobody"s Fool AS …… Carl Roebuck (1994) 　　61.《低俗小说》Pulp Fiction AS …… Butch Coolidge (1994) 　　62.《浪子保镖》North AS …… Narrator (1994) 　　63.《夜色》Color of Night AS …… Dr. Bill Capa (1994) 　　64.《致命距离》Striking Distance AS …… Tom Hardy (1993) 　　65.《重装武器》Loaded Weapon 1 AS …… John McClane, 814 Pacific Coast Highway (uncredited) (1993) 　　66.《飞越长生》Death Becomes Her AS …… Dr. Ernest Menville (1992) 　　67.《超级大玩家》The Player AS …… Himself (1992) 　　68.《虎胆神偷》 又名《哈德森之鹰》......Hudson Hawk (1991) 　　69.《义胆风云》Billy Bathgate AS …… Bo Weinberg (1991) 　　70.《最后战士》The Last Boy Scout AS …… Joseph Cornelius "Joe" Hallenbeck (1991) 　　71.《致命思想》Mortal Thoughts AS …… James Urbanski (1991) 　　72.《虚荣的篝火》The Bonfire of the Vanities AS …… Peter Fallow (1990) 　　73.《看谁又在说话》Look Who"s Talking Too AS …… Mikey (voice) (1990) 　　74.Sinatra 75: The Best Is Yet to Come AS …… Himself (1990) 　　75.Die Harder: The Making of "Die Hard 2" AS …… Himself (1990) 　　76.《看谁在说话》Look Who"s Talking AS …… Mikey (voice) (1989) 　　77.《冷暖天涯》In Country AS …… Emmett Smith (1989) 　　78.Saturday Night Live: 15th Anniversary AS …… Himself (1989) 　　79.《第61届奥斯卡颁奖典礼》The 61st Annual Academy Awards AS …… Himself - Co-Presenter: Best Cinematography (1989) 80.That"s Adequate AS …… Himself (1989) 　　81.Saturday Night Live Episode #15.1 AS …… Himself - Host (1989) 　　82.《落日》Sunset AS …… Tom Mix (1988) 　　83.《虎胆龙威》Die Hard AS …… John McClane (1988) 　　84.The Return of Bruno AS …… Bruno Radolini (1988) 　　85.《盲目约会》Blind Date AS …… Walter Davis (1987) 　　86.The Pointer Sisters: Up All Nite AS …… Himself (1987) 　　87.The 44th Annual Golden Globe Awards AS …… Himself (1987) 　　88.《蓝色月光》Moonlighting AS …… David Addison Jr. (1985) 　　89."Moonlighting" AS …… David Addison Jr. (1985) 　　90.《大审判》The Verdict AS …… Courtroom Observer (uncredited) (1982) 　　91.Guru kommt, Ein AS …… Extra (uncredited) (1980) 　　92.《第一死罪》The First Deadly Sin AS …… Man Entering Diner as Delaney Leaves (uncredited) (1980) 　　93.The Hamster Factor and Other Tales of Twelve Monkeys (1997) AS …… Himself (uncredited) 　　94.Bruno the Kid: The Animated Movie (1996) AS …… Bruno the Kid (voice) 　　95.Pulp Fiction: The Facts (2002) AS …… Himself 　　96.Apocalypse (1998) AS …… Trey Kincaid 　　97.Playboy: The Complete Anna Nicole Smith (2000) AS …… Himself (archive footage) 　　98.Inside "Bandits" (2001) AS …… Himself 　　99.Journey to Safety: Making "Tears of the Sun" (2003) AS …… Himself 　　100.Film-Fest DVD: Issue 3 - Toronto (2000) AS …… Himself 　　101.Conversations with Jon Turteltaub (2000) AS …… Himself 　　102.Scene 71 Filmmakers Workshop (2003) AS …… Himself 　　103.The Making of "The Jackal" (1998) AS …… Himself 　　104."The Sixth Sense": Reflections from the Set (2002) AS …… Himself 　　105.Watch the Mercury Rising (1999) AS …… Himself 　　106.A Kid Becomes the Kid AS …… Himself 　　107.Telling the Story of Us AS …… Himself 　　108.1st Annual Mystery Science Theater 3000 Summer Blockbuster Review AS …… Himself (archive footage) 　　109.Siskel & Ebert: Actors on Acting AS …… Himself 　　110.《终极尖兵》AS Joe Cornelius Hallenbeck （1991）