top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

0 votes
51 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

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...