No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
Hi, Massod Ali, Pls try the below query Select * from tablename where startdate = convert(char,getdate(),103) Thanks&Regards Sakthimeenakshi.S [QUOTE=Masood Ali;331619]Hi All I want to check whether there is a record present in my database with value: StartDate="Todays's Date" where start date is the column name with datatype DATE.[/QUOTE]
Hi KushKashyap;798084, I found the query for the condition gave by you... Pls try the following query.... [code=sql]Select a.username,a.QUIZID,a.DATETIMECOMPLETE,a.SCORE from quiz a inner join (Select b. username,b.quizid,min(b.datetimecomplete)as mdatetimecomplete from Quiz b group by b. username,b.quizid)ss on a. username = ss. username and a.quizid = ss.quizid and a.Datetimecomplete = ss.mdatetimecomplete order …
The End.