Friday, 7 November 2014

SECOND HEIGHEST SAL IN SQL

select name,sal
from(
            select name,sal,ROW_NUMBER() over (order by sal desc) as rowid from sal
      )A
where rowid=2second heighest sal in sql
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Type Script variables

Difference between var,let and const in java script and typescript -----------------------------------------------------------------------...

  • About Me
    Name - Chinnababu ore Working - Thomson reuters international services pvt ltd Location - Bengalore
  • (no title)
    Introduction to WCF Windows Communication Foundation (Code named Indigo) is a programming platform and runtime system for building, co...