1 Replies - 405 Views - Last Post: 17 June 2013 - 02:23 AM Rate Topic: -----

#1 mutmalar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 17-June 13

Query to find Intermediate records

Posted 17 June 2013 - 01:36 AM

I need a solution to select intermediate records in a table (student).

i.e. A table consists of 3000 thousand records. with field name : ID, Name, DOB,Physics, Maths, Chemistry

I need to write a Query to select the records between ID is greater than 1200 and less than 1800 in student table.

The ID is Integer data type.

Expecting a reply,

Regards,

Sriram

--------------------------------------------------------------------------------

Is This A Good Question/Topic? 0
  • +

Replies To: Query to find Intermediate records

#2 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 299
  • View blog
  • Posts: 1,755
  • Joined: 26-March 09

Re: Query to find Intermediate records

Posted 17 June 2013 - 02:23 AM

A simple query like below:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;



Check out this link for more information.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1