Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to do select ....(select.....)

Status
Not open for further replies.
Slicer

Slicer

Technical User
Nov 27, 2001
1
US
How to do this:
select * from (select * from table order by price limit 5,5) order by name
 
Sort by date Sort by votes
don't think mysql support multiple selects. check the latest version of mySQL for this feature. devnull22

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !
 
Upvote 0 Downvote
actually it sure doesn't support subqueries as in SQL Server. But you can workaround. Ion Filipski
1c.bmp


filipski@excite.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
360
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
489
EdLentz
EdLentz
E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
219
EdZzy
E
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
382
EdLentz
EdLentz
Samus Aran
  • Locked
  • Question
Looking for specific data using SELECT
Replies
0
Views
121
Samus Aran
Samus Aran

Part and Inventory Search

Sponsor

Back
Top