Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. How to select rows from table using Name field in sql

How to select rows from table using Name field in sql

Scheduled Pinned Locked Moved Database
tutorialdatabase
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    netsheiksf
    wrote on last edited by
    #1

    for example Abul Azar Mohamed Sheik vazith i want to select names from azar to last record of the table

    L J 2 Replies Last reply
    0
    • N netsheiksf

      for example Abul Azar Mohamed Sheik vazith i want to select names from azar to last record of the table

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      Then you need some selection criteria in your database table that can be used to identify such records.

      1 Reply Last reply
      0
      • N netsheiksf

        for example Abul Azar Mohamed Sheik vazith i want to select names from azar to last record of the table

        J Offline
        J Offline
        Jorgen Andersson
        wrote on last edited by
        #3

        SELECT *
        FROM Table
        WHERE Name >= 'Azar'

        For this query to be efficient, the table should be indexed on the name column

        Wrong is evil and must be defeated. - Jeff Ello[^]

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups