Database

Delete from tableName where [whatever condition you want to use]

DELETE FROM
{table name | view name}
[WHERE search_conditions]

Delete from tablename

Delete from Employees
where Salaries > 50000

DROP TABLE table_name

Truncate Table table_name

id	name
1	name1
10	name1
2	name2
3	name3
11	name3
4	name4

id	name
1	name1
2	name2
3	name3
4	name4

delete from tblname where id in
(
	select id 
	from(select ROW_NUMBER() over(partition by name  order by name) rn,
				Id, name from tblname)X
	where rn <> 1
)

sarang_k wrote:

delete the data from the database

Drop DataBase database_name

Mycroft Holmes wrote:

When he comes back with "I can't truncate the table", you can try explaining foreign keys

Krishhhhhhhhhhhhhh wrote:

Not Fully answered. OK

Krishhhhhhhhhhhhhh wrote:

Stop this bloody replies and do ur job perfectly. otherwise close ur forums

Krishhhhhhhhhhhhhh wrote:

I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete").
When the status is "incomplete",then send a mail daily once to "so and so email id".

Krishhhhhhhhhhhhhh wrote:

Stop this bloody replies and do ur job perfectly. otherwise close ur forums

I are Troll