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: sql express, SQL Function, MS SQL Server, MS SQL SubQuery, MSSQL, MSSQL Aanalysis Service, MSSQL2000 Analysis Services, mySQL, MySQL "MS SQL Server 2005" data import, MySQL server 5, queries, serverver 2008 sql 2005 performance, SQL 2005 ASP.NET Navision aspx.vb, sql 2005 express connect error, SQL 2005 Server / ADO.NET, sql server, SQLServer, sqlserver 2005, sqLserver2005, Server 2005, query, query?, SQL Server 2005, sql server 2005 concurrency, Sql server Subquery returned more than 1 value. This is not permitted when the subquery follows =, SQL, Sql 2000, SQL 2005, sql express, sql express developer CTP windows xp x64 edition, SQL Server 2005, sql server update, sql stored procedure, sql 2000, sql 2000 "sql server express 2005", SQL 2000 Server, SQL 2000 SQL 2005 migration syntax, SQL 20005, 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 Server"