h1

Operatori relationali si clauza between

October 15, 2009

Select IdClient,NumeClient

FROM Clienti
WHERE Data >’1/1/2007′ AND Data< ’12/31/2007′ and IdClient=8

sau se poate folosi clauza between

WHERE Data BETWEEN  ‘1/1/2007′ AND ’12/31/2007’ AND IdClient=8

Unde data este in format luna/zi/an in MSSQL.(SQL SERVER).

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: