h1

Stergerea a 2 inregistrari specificate din totalul de 4 CLAUZA DELETE

November 10, 2009

Fie tabela Tipuri Automobile care contine 4 inregistrari:

tabela

Dorim sa stergem automat inregistrarile 2 si  3 a. i sa ramana in tabela doar 2 inregistrari prima si ultima. Pt.aceasta folosim clauza DELETE astfel:

 

delete

 

O alta varianta ar fi sa folosim si interogarea:

delete2

 

Efect:

efect

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: