Interested to Buy Any Domain ? << Click Here >> for more details...
please give me the answer for this:
query which generates the second highest integer in the table?
- 8 Answers
- 8999 Views
- I also Faced
- E-Mail Answers
Answer Posted / salil
Without using LIMIT
SELECT max( t1.col )
FROM `table` t1
WHERE t1.col < (SELECT max( t2.col ) FROM `table` t2);
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I start mysql in mysql workbench?
How do you stop an access query?
What is mysql common?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
How do I create a new database in mysql?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
What is relational database in mysql?
What is ibdata1?
What mysql means?
How do I install mysql on windows 10 64 bit?
How is myisam table stored?
What is mysql aggregate functions? Explain
Can mysql and mariadb coexist?
What port is mysql running on?
How to copy data from one server to another using php?
