Member Avatar for HugoCore

Hi,

How-To for example:

SELECT * FROM table WHERE columname > '2'

FROM THOSE WHERE columname > '4'

FROM THESE LAST WHERE columname > '6'

Thank you very much,

Core regards :)

  • 2 Contributors
  • 1 Reply
  • 48 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by huangzhi
Member Avatar for huangzhi 
select top 1 *
  from (select * 
             from (select * from table where columname > '2') X 
             where columname > '4') Y
  where columname > '6'
  order by columname desc
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.