Browse by Tags

Home ›

All Tags » sql » query » queries (RSS)

Find nth Max value in sql

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"
Correct my query please

I have written a query: --------------------------------------------------------------------------------------------------------------------------------------------------- select distinct sc.trgid as 'Trg ID', req.trainingname as 'Training Name', convert(varchar, sc.plannedenddate, 105...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by su.rameshraj on 06-30-2008, 12:00 AM
Filed under: queries, sql Query, query, SQL, sql server, sql 2000
Multitable query

Hi there, I have what seemed to look a simple qeury but I get double results or not enough. There are 3 tables Toolboxes Tools ToolsInBoxes * ToolboxID * ToolID * ToolboxID * AllowedSizeID * SizeID * ToolID * Name * Name * Price1WhenPutInToolBox * #toolsInBox * PriceTool1 * Price2WhenPutInToolBox * PriceBox1...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Bonaparte on 11-11-2007, 12:00 AM
Filed under: .NET SQL Server 2000, SQL, sql Query, sql 2000, query, queries, sql join, SQL query SELECT columns, Nested Queries In SQL, sql efficiency, SQL inner join, "SQL Server"
complex SQL select query

Hi all I im trying to write a SELECT query to display a set of my logged in user's 'Friends'. Although the way that i have designed my tables means that its very complex, and im hoping someone out there can tackle it! To start ill show you how i contruct friends: Friends FriendshipID Incrementing PK...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by french_duke on 04-29-2007, 12:00 AM
Filed under: SQL, query, queries, complex, friends
Show the decimal part in query

Hi, In the following query the calculator gives value 3.3 but the query returns 3.0 I need to get the decimal part also. i.e I need to get 3.3 as answer from the query. select cast(66/20 as decimal(6,2)) Need help. Thanks

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by su.rameshraj on 06-19-2008, 12:00 AM
Filed under: queries, query, query?, SQL, sql server