Professional Web Applications Themes

Quick question - ASP

if you want to select top 100 records, you will use SELECT TOP 100 * FROM tableName Is there anyone knows how to find bottom 100 records? Thanks. Karen...

  1. #1

    Default quick question

    if you want to select top 100 records, you will use

    SELECT TOP 100 *
    FROM tableName

    Is there anyone knows how to find bottom 100 records?

    Thanks.

    Karen


    Karen Guest

  2. #2

    Default Re: quick question

    try :

    select top 10 * from tableName order by 1

    "Karen" <karen_lauhotmail.com> wrote in message
    news:eUOlicWRDHA.3796tk2msftngp13.phx.gbl...
    > if you want to select top 100 records, you will use
    >
    > SELECT TOP 100 *
    > FROM tableName
    >
    > Is there anyone knows how to find bottom 100 records?
    >
    > Thanks.
    >
    > Karen
    >
    >

    Chao Gao Guest

  3. #3

    Default quick question

    In the scenario if you have clustered index on a column of
    this table, you can use order by clause (with descending
    order) on that column

    SELECT TOP 100 *
    FROM tableName
    ORDER BY clusteredcol DESC

    >-----Original Message-----
    >if you want to select top 100 records, you will use
    >
    >SELECT TOP 100 *
    >FROM tableName
    >
    >Is there anyone knows how to find bottom 100 records?
    >
    >Thanks.
    >
    >Karen
    >
    >
    >.
    >
    sender Guest

  4. #4

    Default quick question

    User order by descending clause

    Select top 100 * from tablename order by fieldname desc
    >-----Original Message-----
    >if you want to select top 100 records, you will use
    >
    >SELECT TOP 100 *
    >FROM tableName
    >
    >Is there anyone knows how to find bottom 100 records?
    >
    >Thanks.
    >
    >Karen
    >
    >
    >.
    >
    Ricky Guest

  5. #5

    Default Re: quick question

    I want to say thank to all of you. It is really helpful.

    Thanks.

    Karen

    "Karen" <karen_lauhotmail.com> wrote in message
    news:eUOlicWRDHA.3796tk2msftngp13.phx.gbl...
    > if you want to select top 100 records, you will use
    >
    > SELECT TOP 100 *
    > FROM tableName
    >
    > Is there anyone knows how to find bottom 100 records?
    >
    > Thanks.
    >
    > Karen
    >
    >

    Karen Guest

  6. #6

    Default Quick Question

    In my asp.net page I am currently showing an XML Doent
    using the XML Object. What I am trying to accomplish is in
    the tags of the XMLDoent adding HTML as Below

    <PowerViewXMLDoent>
    <Row>
    <C001>
    Data for row 1<Span style="BACKGROUND-
    COLOR: blue">Some Text</Span>
    </C001>
    </Row>
    <Row>
    <C001>Data for row 2</C001>
    </Row>
    ...
    </PowerViewXMLDoent>

    Simply put....trying to color the background of some text
    by inserting HTML tags into the XML. Is this possible? Is
    there a better way?
    Thanks for the help!

    Jorell
    Jorell Guest

  7. #7

    Default Quick question

    how can I count specific charaters in a string?

    like the amount of backslashes in-

    "D:\Inetpub\site\this\string"



    TIA


    Qwip Guest

  8. #8

    Default Re: Quick question

    sString = "D:\Inetpub\site\this\string"
    iNumberOfSlashes = UBound(Split("\" & sString, "\")) - 1

    Ray at work


    "Qwip" <asdasemailasdasd.com> wrote in message
    news:eh3tqg6gDHA.3784tk2msftngp13.phx.gbl...
    > how can I count specific charaters in a string?
    >
    > like the amount of backslashes in-
    >
    > "D:\Inetpub\site\this\string"
    >
    >
    >
    > TIA
    >
    >

    Ray at Guest

  9. #9

    Default Re: Quick question



    [url]http://www.aspin.com/func/search?cob=aspkey&qry=count+characters[/url]


    --
    ================================
    [url]http://www.ASPkey.net/[/url]
    A Resource Site for Web Developers
    *Free OnLine web Tools
    *Free development services
    ================================


    "Qwip" <asdasemailasdasd.com> wrote in message
    news:eh3tqg6gDHA.3784tk2msftngp13.phx.gbl...
    > how can I count specific charaters in a string?
    >
    > like the amount of backslashes in-
    >
    > "D:\Inetpub\site\this\string"
    >
    >
    >
    > TIA
    >
    >

    TJS Guest

  10. #10

    Default Re: Quick question

    Thank you
    Thank you


    "Qwip" <asdasemailasdasd.com> wrote in message
    news:eh3tqg6gDHA.3784tk2msftngp13.phx.gbl...
    > how can I count specific charaters in a string?
    >
    > like the amount of backslashes in-
    >
    > "D:\Inetpub\site\this\string"
    >
    >
    >
    > TIA
    >
    >

    Qwip Guest

  11. #11

    Default Quick question

    Hi,

    Is there any command to know which application/program is listening
    on a given socket.

    For example, some daemons are running on the current system.
    I want to know what application is listening on socket 1234.

    Is this possible??

    Thanks in advance.
    tvr1729
    tvr Guest

  12. #12

    Default Re: Quick question

    On 15 Nov 2003 18:21:06 -0800, tvr wrote:
    > Hi,
    >
    > Is there any command to know which application/program is listening
    > on a given socket.
    >
    > For example, some daemons are running on the current system.
    > I want to know what application is listening on socket 1234.
    >
    > Is this possible??

    netstat -ta # maybe
    Bit Twister Guest

  13. #13

    Default Re: Quick question

    Bit Twister <BitTwisterlocalhost.localdomain> wrote in message news:<slrnbrdnoi.6ks.BitTwisterwb.home>...
    > On 15 Nov 2003 18:21:06 -0800, tvr wrote:
    > > Hi,
    > >
    > > Is there any command to know which application/program is listening
    > > on a given socket.
    > >
    > > For example, some daemons are running on the current system.
    > > I want to know what application is listening on socket 1234.
    > >
    > > Is this possible??
    >
    >
    > netstat -ta # maybe
    Nestat displays all the ports...
    I want a specific port.

    tvr
    tvr Guest

  14. #14

    Default Re: Quick question

    On 16 Nov 2003 18:20:02 -0800, tvr wrote:
    >
    > Nestat displays all the ports...
    > I want a specific port.
    Then pipe it through grep.
    Bit Twister Guest

  15. #15

    Default Re: Quick question

    Hi,

    Try the open source command 'lsof'. If you don't have it get it here:

    [url]http://freshmeat.net/projects/lsof/[/url]

    If you are working on Solaris 5.8 > then 'pfiles' is a good choice, however
    you will have to filter the output to get the info you need in this case.

    --- aj ---

    "tvr" <tvr1729> wrote in message
    news:6f4d9f70.0311151821.1cd060bdposting.google.c om...
    > Hi,
    >
    > Is there any command to know which application/program is listening
    > on a given socket.
    >
    > For example, some daemons are running on the current system.
    > I want to know what application is listening on socket 1234.
    >
    > Is this possible??
    >
    > Thanks in advance.
    > tvr1729

    Andrew Jury Guest

  16. Moderated Post

    Default Re: Quick question

    Removed by Administrator
    Ulrich Herbst Guest
    Moderated Post

  17. Moderated Post

    Default Re: Quick question

    Removed by Administrator
    tvr Guest
    Moderated Post

  18. #18

    Default Re: Quick question

    > So you see, I cant make out what the process is.
    I'm a newbie to linux so maybe I'm off the mark here, but I found the -p
    returns the name of the program on that port. It seems like you netstat
    installed cause you're getting stuff back, what do the man pages say for
    programs?


    Flip Guest

  19. #19

    Default Re: Quick question

    "Flip" <[remove]phenry_whotmail.com> wrote in message news:<eP4vb.5658$G1.26726tor-nn1.netcom.ca>...
    > > So you see, I cant make out what the process is.
    > I'm a newbie to linux so maybe I'm off the mark here, but I found the -p
    > returns the name of the program on that port. It seems like you netstat
    > installed cause you're getting stuff back, what do the man pages say for
    > programs?

    Man pages say,
    -p is used to "Show the net to media tables."

    Thanks
    tvr
    tvr Guest

  20. #20

    Default Re: Quick question

    tvr wrote:
    > Man pages say,
    > -p is used to "Show the net to media tables."
    Have you got lsof? If so this may show what program is using the socket
    you mention, "lsof -n -i" may be what you need.

    ---
    Money can't buy happiness, but allows a choice of misery.

    Andy Hibbins Guest

Similar Threads

  1. very quick question
    By quiero mas in forum Coldfusion Database Access
    Replies: 6
    Last Post: November 11th, 05:47 AM
  2. Quick CSS question
    By David in forum HTML & CSS
    Replies: 13
    Last Post: October 22nd, 04:33 PM
  3. quick MX question....
    By Frances Del Rio in forum Macromedia Flash
    Replies: 3
    Last Post: April 21st, 01:54 PM
  4. A Quick Question
    By Trevor Neilson in forum Macromedia Flash
    Replies: 2
    Last Post: September 30th, 09:05 PM
  5. QUICK SSA QUESTION
    By Ken in forum AIX
    Replies: 2
    Last Post: July 14th, 04:08 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139