top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to write a query to display the records between two range in SQL?

0 votes
201 views
How to write a query to display the records between two range in SQL?
posted Sep 22, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

SELECT * FROM dt_tb WHERE month(dt) between '02' and '08';

for more details please refer : http://www.plus2net.com/sql_tutorial/between-date.php

answer Sep 24, 2014 by Arun Gowda
Similar Questions
+3 votes

How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000 in Oracle?

+2 votes

suppose if i give '12345'

output should be:

1
12
123
1234
12345
1234
123
12
1

...