rgb192
asked on
select number(varchar) from payments where paymentid(int) is the smallest/ largest
CREATE TABLE [dbo].[payments](
[paymentid] [int] IDENTITY(1,1) NOT NULL,
[orderid] [int] NOT NULL,
[dateentered] [datetime] NULL,
[datebilled] [datetime] NULL,
[type] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_ AS NOT NULL,
[number] [varchar](80) COLLATE SQL_Latin1_General_CP1_CI_ AS NOT NULL,
[expiration] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
[CV2] [int] NOT NULL,
[confirmation] [varchar](70) COLLATE SQL_Latin1_General_CP1_CI_ AS NOT NULL,
[resultcode] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_ AS NOT NULL,
[debit] [money] NOT NULL,
[paymentinfo] [text] COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
[ebayquantity] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
[paymentfee] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
[email] [varchar](300) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
CONSTRAINT [PK_payments] PRIMARY KEY CLUSTERED
(
[paymentid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
select number(varchar) from payments where paymentid(int) is the smallest
and another query
select number(varchar) from payments where paymentid(int) is the largest
[paymentid] [int] IDENTITY(1,1) NOT NULL,
[orderid] [int] NOT NULL,
[dateentered] [datetime] NULL,
[datebilled] [datetime] NULL,
[type] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_
[number] [varchar](80) COLLATE SQL_Latin1_General_CP1_CI_
[expiration] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_
[CV2] [int] NOT NULL,
[confirmation] [varchar](70) COLLATE SQL_Latin1_General_CP1_CI_
[resultcode] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_
[debit] [money] NOT NULL,
[paymentinfo] [text] COLLATE SQL_Latin1_General_CP1_CI_
[ebayquantity] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_
[paymentfee] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_
[email] [varchar](300) COLLATE SQL_Latin1_General_CP1_CI_
CONSTRAINT [PK_payments] PRIMARY KEY CLUSTERED
(
[paymentid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
select number(varchar) from payments where paymentid(int) is the smallest
and another query
select number(varchar) from payments where paymentid(int) is the largest
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER