Hi all, I am using SQL 2005 Express, I have a table like this, Table Name : Employee Eid Name Salary 1 harry 3500 2 jack 2500 3 john 2500 4 xavier 5500 5 steven 7500 6 susana 2400 I would like to select the nth maximum salary in this table, and suppose if there is 100 records in this table, i want to...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
prnkrish
on
08-28-2008, 12:00 AM
Filed under: MSSQL Aanalysis Service, MySQL "MS SQL Server 2005" data import, MySQL server 5, query, query?, Server 2005, serverver 2008 sql 2005 performance, SQL, Sql 2000, sql express, sql express developer CTP windows xp x64 edition, SQL Server 2005, sql server update, sql stored procedure, sql 2000, SQL 2000 Server, SQL 2000 SQL 2005 migration syntax, sql 2005, Sql 2005 .NET, SQL 2005 .NET ExecuteNonQuery, SQL 2005 .NET full-text indexing, sql 2005 .NET Select query limits, SQL 2005 ASP.NET, SQL 2005 ASP.NET Navision aspx.vb, SQL 2005 Server / ADO.NET, sql express, SQL Function, SQLServer, sqlserver 2005, sqLserver2005, MS SQL Server, MS SQL SubQuery, sql server, sql server 2005 concurrency, mySQL, queries, SQL 2005, sql 2000 "sql server express 2005", SQL 20005, sql 2005 express connect error, "SQL Server", SQL Server 2005, MSSQL, MSSQL2000 Analysis Services, Sql server Subquery returned more than 1 value. This is not permitted when the subquery follows =