Loading

SQL query problem

darma teja

Hi,

I can not retrieve the data from the data base by using query. Where I missed...

Actually my database has column name as Date with DateTime property.

I wrote query like this:

select Name from Table1 where Date like '2012-12-%' group by Name;

Thanks,

Darma

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Singh Shekhawat13y ago
Accepted answer
In The query has following problems:

1. If Table has no data.
2. What format data store in Date Column because it can search according

For example :

I have Table with data in following format:

Query:
SELECT NAME FROM Table1 WHERE CONVERT(VARCHAR(25), Date, 126) like '2012-12-%' GROUP BY Name

OutPut:

Thanks
Sandeep
0
Vishnujeet Kumar13y ago
select Name from Table1 where Date like '2012-12-1%'
0