|
View previous topic :: View next topic
|
| Author |
Message |
umakanth.ravirala
New User
Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom
|
|
|
|
Hi please give me a query which will give bill date with out at on it
Example is given below
BILL_DTE CDE
01.01.2007 AT
01.01.2007 TC
01.01.2007 TF
02.02.2007 TF
02.02.2007 TC
02.02.2007 TS
Here date 01.01.2007 hat AT on it so I don’t want to retrieve that date any where Just I want to retrieve a date with out AT atleast once on it
Ex: BILL_DTE = 02.02.2007
regards....
Umakanth |
|
| Back to top |
|
 |
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi,
| Quote: |
| Here date 01.01.2007 hat AT on it so I don’t want to retrieve that date any where Just I want to retrieve a date with out AT atleast once on it |
Pls clear your quetion. |
|
| Back to top |
|
|
umakanth.ravirala
New User
Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom
|
|
|
|
hi
in that example there is AT for date 01.01.2007 so i dont want that date
i want only dates without AT atleast once |
|
| Back to top |
|
|
VinayCM
New User
Joined: 06 Nov 2007
Posts: 36
Location: Bengaluru
|
|
|
|
Umakanth,
I hope this query works.. check it out..
SELECT BILL_DTE FROM TBL_NAME
WHERE CDE <> 'AT' |
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi
Pls try the query below
| Code: |
| SELECT BILL_DTE FROM TABLE WHERE CDE NOT = "AT"; |
try this query and let me know. Before executing check the syntax also. |
|
| Back to top |
|
|
umakanth.ravirala
New User
Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom
|
|
|
|
hi vasanth i got it
select bill_dte from table where bill_dte not in (select bill_dte from table where cde='AT'); |
|
| Back to top |
|
|
|
|
