Skip to main content

Secound and third highest number in Mysql and Sql query and Count row of a specific coloumn in table in Mysql and Sql query and Find out minimum value of a specific column in Mysql and sql query and Find out minimum and maximum value of a specific column in Mysql and sql query

Secound and third highest number in Mysql and Sql query:-syntax:-

SELECT Budget FROM customer order by budget DESC LIMIT 1,2

Count row of a specific coloumn in table in phpsyntax:-

SELECT COUNT(Used) as a FROM audit

Find out minimum value of a specific column in Mysql and sql query:-syntax:-

SELECT MIN(Used) as a FROM audit

Find out minimum and maximum value of a specific column in Mysql and sql query:-syntax:-

SELECT MIN(Used) , max(Used) FROM audit

Comments

Popular posts from this blog

FILE UPLOAD IN PHP BY USEING FORM | PHP FILE UPLOADS

FILE UPLOAD IN PHP  BY USEING FORM | PHP FILE UPLOADS INDEX.PHP //PAGE <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form method="post" action="upload.php" enctype="multipart/form-data"> <input type="file" name="posters" /> <input type="submit" value="upload" name="submit" /> </form> </body> </html> upload.php //PAGE <?php if($_FILES) { $name=$_FILES['posters']['name']; $type=$_FILES['posters']['type']; $extension=array('jpeg','jpg','JPEG','JPG','...