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
Labels:

Comments

Post a Comment

Popular posts from this blog

how send mail using Swift mailer | switmailer send mail tutorial

how send mail using Swift mailer | switmailer send mail tutorial  <?php /* step 1 include Swift mailer file ;  */ include("vendor/swiftmailer/swiftmailer/lib/swift_required.php"); /* step 2 create your user details */ $senderEmail="saddam1234321@gmail.com"; $senderPassword="****Your password****"; $senderName="Saddam huassin"; /* step 3 set SMTP host  for sending mail  */ $user = Swift_SmtpTransport::newInstance('smtp.gmail.com','587','tls'); /* step 4 set your user details  */ $user->setUsername($senderEmail); $user->setPassword($senderPassword); /* step 5 create swift  mailer instance with a variable */ $mailer = Swift_Mailer::newInstance($user); /* step 6 Create a message */ $message = Swift_Message::newInstance('Wonderful Subject')   ->setFrom(array($senderEmail => $senderName))   ->setTo(array($senderEmail))   ->setBody('Here is the message itsel...
Post a Comment
Find more ----»

how install Swift mailer in localhost | swift mailer installation | composer install swift mailer

how install Swift mailer in localhost | swift mailer installation | composer install swift mailer Step 1:- open cmd  Step 2;- copy this command " composer required swiftmailer/swiftmailer @stable " . Step 3;- paste in cmd and press enter. Step 4;- after few second swift mailer ready to use ................................. 
Post a Comment
Find more ----»