Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

Request Friendship



Upload Image

32 years old
Madurai, Tamilnadu, India
Male
Guru Samy
9 · 16% · 5042

Guru Samy - TSQL Beginners Challenges

  • Solution to challenge 1

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    My solution...
    vinit
    857 · 0% · 34
  • TSQL Beginners Challenge 1

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    Without Rank...
    SylvainTheroux
    2274 · 0% · 6
  • Solution

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    Pretty straightforward...
    baziol89
    2274 · 0% · 6
  • TSQL Beginners Challenge 1 - Solution

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    ...
    Nimit Goyal
    1336 · 0% · 18
  • Solution

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    with CTE as(select row_number() over(partition by deptno order by salary desc) row,salary,deptno from empname) select * from CTE where row=2 ...
    ravituvar
    617 · 0% · 58
  • Find the second highest salary for each department

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    ;with CTE_SAL(EmployeeID, EmployeeName, Department, Salary,ROW_ID) AS(select top 2 EmployeeID, EmployeeName, Department, Salary ,ROW_NUMBER() OVER(ORDER BY SALARY DESC) from employees) select EmployeeID, EmployeeName, Department, Salary from CTE_SAL ...
    satheeshv
    1808 · 0% · 11
  • solution

    Guru Samy Liked 5 Years ago through TSQL Beginners Challenges | 1 Point
    Just use a CTE to calculate a RANK, partitioned by Department and ordered by Salary. Then select from the CTE where Rank = 2...
    marc_jellinek@hotmail.com
    96 · 2% · 586
Previous 1 | 2 | 3 Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.