Hi..
As everyone knows that there's a keyword in MySQL that is used to limit the records in SELECT statement as
SELECT * FROM Table LIMIT 40,10
means that select from record 40 to onward 10 records.
In SQL Server it is a long way with nested select ... can someone provide an alternate or we have to use the Nested SELECT?
Thanks
Yes
U can specify
select top n * from tablename
similarly u can also specify top n percentage in a select statement.
Check for Keyword top in sql Help
|||Nested select (technically called a derived table) is the best way to go in SQL. Here are a few articles that cover the subject.
http://www.sqlmag.com/Article/ArticleID/43922/sql_server_43922.html
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/03/4945.aspx
http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx
