I need SQL query to find between two date and another column by name

Question

SELECT * 
FROM claz 
WHERE student AND (BETWEEN date AND date)

I have this one table claz, and I need to search to find student records between date periods

Ok, and what seems to be the problem with what you have so far? — Richard Tingle, Nov 23 '13 at 09:51
i need to add student column to this for find student with between date — krishantha ukwatta, Nov 23 '13 at 09:55

score 0 · Accepted Answer · edited Nov 23 '13 at 11:04

0

You may try to use it like this:

SELECT *  
FROM claz  
WHERE student = 'somevalue'
  AND date_column BETWEEN '2013/02/25' AND '2013/02/27'

or like this:

SELECT *  
FROM claz  
WHERE student = 'somevalue'
  AND date_column >'2013/02/25' AND date_column <'2013/02/27'

But it not very clear what you are trying to achieve

edited Nov 23 '13 at 11:04

Hawk

answered Nov 23 '13 at 09:52

Rahul Tripathi

thanks but i need to add student column to this for find student with between date – krishantha ukwatta Nov 23 '13 at 09:54
@krishanthaukwatta:- I am really sorry but I am not understanding your point. Could you please explain what you want? Do you want student column also to be added? – Rahul Tripathi Nov 23 '13 at 09:56
hey rahul thanks.. thats ok this sytax is correct thank youuu..........!!!! :D – krishantha ukwatta Nov 23 '13 at 10:07

score 0 · Answer 2 · answered Nov 23 '13 at 09:53

0

Try:

SELECT * FROM claz
WHERE student = ?
AND date BETWEEN date1 AND date2;

Not sure thought what your student should match and what name your date-column has. Couldn't test it, as I am not near my DB at the moment.

answered Nov 23 '13 at 09:53

Armunin

score 0 · Answer 3 · answered Nov 23 '13 at 09:54

0

try this..

SELECT * FROM claz WHERE student = 'BG' AND date < maxdate AND date > mindate;

answered Nov 23 '13 at 09:54

subash

score 0 · Answer 4 · edited Nov 23 '13 at 11:03

0

try this

SELECT * 
FROM claz 
WHERE student='name' 
  AND date BETWEEN 'date one' AND 'date two'

edited Nov 23 '13 at 11:03

Hawk

answered Nov 23 '13 at 09:55

4 Answers4