How will you delete a particular row from a Table?

Answer Posted / mohan

delete from emp where empno=&n;

Note:
1. Here &n means the empno which we have to delete from the table.
2. In general we will use primary key column in where clause.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define SQL and state the differences between SQL and other conventional programming Languages?

694


How is data stored on a disk?

551


What is sql performance tuning?

501


How many commands are in sql?

533


what is oltp (online transaction processing)? : Sql dba

538






What is %s in sql?

575


What are all ddl commands?

555


What is varchar used for?

543


Can we use ddl statements in stored procedure sql server?

524


How do you pronounce sql?

556


What is difference between db2 and sql?

537


What is data abstraction in sql?

517


What is sql*loader?

576


define join and explain different type of joins? : Sql dba

552


What is sql resultset?

538