Jump to content

bhavik_solanki

Members
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

 Content Type 

Everything posted by bhavik_solanki

  1. bhavik_solanki
    Try this. This will return only records start with number. will not even blank.Select * from Books Where Title like '[0-9]%'
  2. bhavik_solanki
    Delete From EmpSalary where EmpId In( Select A.EmpId From EmpSalary A,EmpSalary B Where A.EmpId > B.EmpId And A.Salary = B.Salary )
  3. bhavik_solanki
    Try This QueryUpdate User2 Set UId = User1.Uid From User1 Where User1.UserName = User2.UserName
  4. bhavik_solanki
    In SQL server u can try this querySelect Distinct Top 2 salary from EmpSalary Order by salary Desc
×
×
  • Create New...