Search:

Type: Posts; User: ssuvi; Keyword(s):

Search: Search took 0.00 seconds.

  1. SQL Server - Re: Give example of mixmize and minimum salary find.

    Replace "n" with the no. u want to get the nth highest salary.
    select *
    from emp e1
    where ( n =
    ( select count ( distinct ( e2.sal ) )
    from emp e2
    where e2.sal >=e1.sal))
  2. Answers
    4
    Views
    40,781

    Re: How to prepare for attending accenture

    hi
    i know this is too late 4 me 2 post in this thread. anyway,assuming someone may benefit from diz,

    in accy 4 on campus recruitment, u hav a written test which mostly consists of aptitude from...
  3. Thread: DB2 query

    by ssuvi
    Answers
    2
    Views
    5,789

    DB2 - Re: DB2 query

    Query to select top nth record:

    consider the table name as emp,then

    select empid
    from emp e1
    where ( n =
    ( select count ( distinct ( e2.empid ) )
    from emp e2
    where e2.empid >=e1.empid))
  4. Answers
    28
    Views
    14,929

    Re: What is a output?. How will Come?.

    I think m=0
Results 1 to 4 of 5
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact