Viewing 5 posts - 1 through 5 (of 5 total)
Found..ITs a bug in MSSQL 2005.
October 31, 2011 at 5:44 pm
top 5th Salary of every department
SELECT * FROM (
SELECT EMP_ID, DEPT_ID, SALARY, NAME
,RANK() OVER (PARTITION BY DEPT_ID ORDER BY SALARY DESC) AS RANKID
FROM EMP) A WHERE RANKID = 5
August 17, 2009 at 11:49 pm
This is quite a contrary queston..The max size of the database is a capacity planning chapter. If your Physical server can support, you can have a DB size in TB's....
November 29, 2006 at 2:48 am
This is indeed amazing, However, there is a possiblity that sometimes the sysobjects table may go correct and so the Database engine does not finds the table.
Possible reason ??
November 29, 2006 at 2:42 am
The duplicate records delete query solved my issues.. thanks to the community..
July 27, 2004 at 6:27 am
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy