please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / sunil kumar
Sorry I have a mistake in above answer. The right answer is
select marks from tablename order by marks desc limit 1,1
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is row?
How can you find out the version of the installed mysql?
How to change a password for an existing user via mysqladmin?
How do I clear a mysql database?
How to use sum function in where clause in mysql?
What is relational database in mysql?
What is 1nf 2nf 3nf?
How do stored procedures work?
How do I rename a table in mysql?
Where is mysql data stored linux?
What is the difference between truncate and delete?
What is mysql_query?
How do I remove a user from mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?