Results 1 to 2 of 2

Thread: [RESOLVED] Limited selecton of records

  1. Sep 23rd, 2019, 08:10 AM #1
    AndreB82
    AndreB82 is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2018
    Posts
    90

    Resolved [RESOLVED] Limited selecton of records

    Dear all,
    I have a table in SQL which consists of 3 columns:

    Id | Code | Image

    I can have in it different images with the same Code. Sorting by id, I would like to be able to select just the "first-four" images to display them in four pictureboxes in my form.

    How could I handle this?

    Thanks for suggestions,
    A.
    Reply With Quote Reply With Quote
  2. Sep 23rd, 2019, 09:04 AM #2
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: Limited selecton of records

    Add a Top(4) and order by clause to the select
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width