bhavik_solanki

Try this. This will return only records start with number. will not even blank.Select * from Books Where Title like '[0-9]%'

Sir plz tell me "how to delete duplicate row from a table". thanks.bye.....

Delete From EmpSalary where EmpId In( Select A.EmpId From EmpSalary A,EmpSalary B Where A.EmpId > B.EmpId And A.Salary = B.Salary )

Try This QueryUpdate User2 Set UId = User1.Uid From User1 Where User1.UserName = User2.UserName

plz help me.... I want to find" top 5 sal from emp" how can we find???thanks.

In SQL server u can try this querySelect Distinct Top 2 salary from EmpSalary Order by salary Desc