Browse by Tags

Home ›

All Tags » query » mysql (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: 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 =
MySQL Query with a variable on ASP.net

Using, VWD 2008 express, I've been working through a MS tutorial called "Creating Master/Detail Web Pages in Visual Studio." The tutorial is simple. A dropdown list, set to autopostback from a table, that when selected, pulls up the data based on the variable category id. What I have works...

Posted to MySQL (Forum) by Jay-B on 10-07-2009, 12:00 AM
Filed under: mysql, asp.net, visual web developer 2008 express, query, variable
Question on automating a MySQL query LIMIT statement

I asked this somewhere else, but since I'm using ASP.net with MySQL, I'm going to ask this in here, too: I have a large database that has multiple items associated with one group. What I was doing was searching the table for items with the group ID, and then doing a LIMIT X ASC statement manually...

Posted to MySQL (Forum) by Jay-B on 10-10-2009, 12:00 AM
Filed under: mysql, asp 3.5, query
Re: How would I write this MSSQL statement in MySQL anyone please?

Not sure if this works but give it a try: select id, (select value from tbl2 where tbl2.id = tbl1.id order by tbl2.date desc limit 0, 1 ) from tbl1 There is no TOP N clause in mysql, so instead, use its replacement LIMIT 0, N

Posted to MySQL (Forum) by salman_arshad on 07-25-2009, 12:00 AM
Filed under: mysql, query