Using AND in query
| От | aravind chandu |
|---|---|
| Тема | Using AND in query |
| Дата | |
| Msg-id | 853899.68325.qm@web31405.mail.mud.yahoo.com обсуждение |
| Ответы |
Re: Using AND in query
Re: Using AND in query Re: Using AND in query |
| Список | pgsql-general |
Hello every one,
I have encountered a problem while working .I have a sample table with the following data
| TID | Date | Item |
| T100 | 8/1/2010 | Laptop |
| T100 | 8/1/2010 | Desktop |
| T101 | 8/1/2010 | Laptop |
| T102 | 8/1/2010 | Desktop |
| T103 | 8/2/2010 | Laptop |
| T103 | 8/2/2010 | Desktop |
| T104 | 8/2/2010 | Laptop |
need the data when a person bought laptop & desktop on the sameday.I used a condition in where clause but its not working,it is returning no rows.Can any one please help me to resolve this issue ?
condition in where clause :
table.date in date() to date() and table.item = "laptop" and table.item = "Desktop"
В списке pgsql-general по дате отправления: