Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL Need help on mySQL 5
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Christopher De Souza
Need help on mySQL 5
2 Answer(s)      5 years and 2 months ago
Posted in : SQL



Advertisement
View Answers

September 2, 2009 at 6:47 PM


dear user
you have to use a nested sql query as given below:-

select word,no_of_searches from animal where no_of_searches=(select max(no_of_searches) from animal);


September 3, 2009 at 1:12 PM


Hi Friend,

Use the following query:

select word,num_of_searches from animals where num_of_searches=(select max(num_of_searches) from animals);

Thanks


Related Tutorials/Questions & Answers:
Need help on mySQL 5 - SQL
Need help on mySQL 5  Dear Sir, I'm a beginner of mySQL 5 . I need help on mySQL5 command. This is the table which i created is called... by using Aggregate function(MAX). May i know that what command i need
Help on mySQL 5 command line - SQL
Help on mySQL 5 command line  Dear Sir, I had created a table for mySQL 5 called dictionary as shown below: mysql> select * from dictionary; +----+------+-------------------------? | no | word | explanation | num
Advertisements
help on mySQL 5 command Line - SQL
help on mySQL 5 command Line  Dear Sir, Sorry for my mistake, please ignore the first post of my question I had created a table for mySQL 5 called dictionary as shown below: mysql> select * from dictionary
Need help to create Struts 2 MySQL based HRMS application.
Need help to create Struts 2 MySQL based HRMS application.   Hi Sir, I am doing my project based on Human Resource Management system using struts 2... given here. Some are working but some are not. Can you please help me to create
upgrade mysql 4 5 cpanel
upgrade mysql 4 5 cpanel  upgrade mysql 4 5 cpanel
Need help with this!
Need help with this!  Can anyone please help me... to a file at all at this time. Any help would be greatly appreciated, thank you...(); restart=1; entry = 1; //creating menu while(entry > 0 && entry < 5
Need help
Need help  Hello... I need some help I have a method which contains 1 string value and i wnat when this method get called den that string value should b assigned as array name.. for example.. i have a method name() which
Need help
Need help  Hello... I need some help I have a method which contains 1 string value and i wnat when this method get called den that string value should b assigned as array name.. for example.. i have a method name() which
Need help
Need help  Dear sir, I have a problem. How to write JSP coding, if a user select a value from drop down list for example department, the another drop.... This name list should get from the database. Please help me. By the way, I'm
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql  i am working on a project... such program if u can provide me...plz plz...help i need the idea/code/implementation
Help on JDBC and my SQL 5 database - JDBC
Help on JDBC and my SQL 5 database  Dear Sir, I had create... the connection c = DriverManager.getConnection ("jdbc:mysql... a Jtextfield (txtSearch.getText()) match with mySQL database field
Need Help on JMS - JMS
Need Help on JMS   Hi, In my application i need to create my own ques and my own QueueConnectionFactory..... Plz tell me how to create the same... Any help is appriciated,.. Thanks in advance
i need a help in this please
i need a help in this please  The factorial of a nonnegative integer n is written n! (pronounced ‚?? n factorial‚??) and is defined as follows: n!=n... (for n=0) for example, 5!=5.4.3.2.1, which is 120 a) Write an application
Need help with nested queries
Need help with nested queries  Hello, Table1 has "id", "votes" columns. Table2 has "id", "Name" column. I need to retrieve Name and its corresponging Votes. I tried with nested queries but its confusing. Can anyone please help
Need Help on the script
Need Help on the script  hello there, My name is Femi and am a web... dont know if you can help me out with it. The platform am building will receive a text message and the format of the text message is "shoe, 40, bag, 5, tea,1
need help - Java Beginners
need help  Need help in programming in Java  Simple java...; System.out.print('"'); System.out.println(); } i=5; while(i>=1){ for(j=1;j<=i...;class Stars{public static void main(String[] args){int a = 1, b = 5, c, d, i;while
need help with program
need help with program  To write a program to read a set of words from a file and return the following 1)Each word in the file against its frequency 2) the frequency should be in the descending order of the frequencies
Need Help in Java programming
Need Help in Java programming  Hello. Can someone please help me with writing the following program Java program that gives assignment details such as:assignment number,assignment name,due date,submission date,percentage marks
need help please
need help please  Dear sir, my name is logeswaran. I have a big problem that I can't find the solution for a program. How can I block a user from enter a page second time. Please help me. By the way I'm using Access database
need help to create applet
need help to create applet  Can u help me..?? I get a task ...and i dont know how to make it... So I hope that u can help me... Here is the task... e) CardLayout If u can help me, then please
need help with program
need help with program  To write a program where we can take two integer array as input,Find the missing number from array"B" has all the numbers from array"A" except one,and find the fastest way in doing
Friends need a help on ruby..
Friends need a help on ruby..  Friends i need a ruby script and the requirement is When i am running a ruby script in cmd, after executing my script, a html report will be generated having my console output details. For ex
Need help on JAVA JSP
Need help on JAVA JSP  Hi, I have never worked on java and I have been given an assignment where I have to fix existing issues in the tool(created...(need to know how I can adjust it based on the cureen system's screen resolution
Need some help urgently
Need some help urgently  Can someone please help me with this below question. I need to write a class for this. If you roll Y standard six-sided dice... need to write a class for this where X and Y are passed as parameter. If someone
need help...................please
need help...................please  I have a problem in my JSP Coding... on this area. Please help me. By the way, I'm using access Database and JSP coding... = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test","root","root"); String
hello there i need help
hello there i need help  : i need to do a program like this: Automatic Teller Machine [B] Balance [D] Deposit [W] Withdrawal [Q] Quit select you... i am a beginner, and aside from that i am really eager to learn java please help
Need Help With This Scenario
Need Help With This Scenario  The bonnet of a car is opened to determine if there is anything wrong with the engine. Firstly, the radiator water is checked. If the radiator water is below the minimum indicator level
Need Help With This Scenario
Need Help With This Scenario  The bonnet of a car is opened to determine if there is anything wrong with the engine. Firstly, the radiator water is checked. If the radiator water is below the minimum indicator level
Need help with console program?
Need help with console program?  Write a console program that repeatedly prompts the user to enter data until they type done (any case, Upper, Lower, or Mixed). thanks in advance.   Here is an example that repeatedly
Need Help - Java Beginners
Need Help  Hello Sir, Am a beginner of Java. Also i did course on J2EE... but dont have any ideas about real time projects. But i want to do some projects in Java as well as J2EE... Can u help me and guide to do a project
Need help with my project
Need help with my project  Uses a while loop to perform the following steps: -Prompt the user to input two integers: firstNum and secondNum where secondNum is at least 10 greater than firstNum, both numbers are positive integers
Advertisements
 

 

 

DMCA.com