query to fetch the highest record in a table

query to fetch the highest record in a table

Write a query to fetch the highest record in a table, based on a record, say salary field in the empsalary table

View Answers

November 19, 2010 at 5:39 PM

Hi,

The query string to fetch the highest record from a table is -

Select max(salary) from empsalary;

Thanks,









Related Tutorials/Questions & Answers:
query to fetch the highest record in a table
query to fetch the highest record in a table  Write a query to fetch the highest record in a table, based on a record, say salary field in the empsalary table
fetch record from MYsql table query
fetch record from MYsql table query  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table
Advertisements
Write a query to insert a record into a table
Write a query to insert a record into a table  Write a query to insert a record into a table   Hi, The query string is as follows-ADS_TO_REPLACE_1 Insert into employee values ('35','gyan','singh'); Thanks
Write a query to delete a record from a table
Write a query to delete a record from a table  Write a query to delete a record from a table   Hi, The query string for the delete operation is as follows-ADS_TO_REPLACE_1 delete from employee where id='35'; Thanks
3rd&5th highest salary from a table
3rd&5th highest salary from a table  how we get 3rd highest and 5th highest salary from a table
retrieve record from table
retrieve record from table  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually
how to fetch the record using AJAX? - Ajax
how to fetch the record using AJAX?  Can anyone tell me how to fetch the records from database using Ajax
retrieve record from the field table
retrieve record from the field table  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table
How to retrieve record from table
How to retrieve record from table  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table
JDBC : Find Highest salary
JDBC : Find Highest salary In this tutorial, we are showing how to find record of highest salary employee. MAX() : MAX() method returns the highest... example we are displaying record of such employee who has highest salary among all
MySql Databse query to fetch results from database
MySql Databse query to fetch results from database  Hi. I have... chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values
JDBC : Find second highest salary
record of employee having second highest salary. Find second highest salary... to find out second highest salary so you can write different logical query to get second highest salary.ADS_TO_REPLACE_1 Employee Table
JDBC : Find Third highest salary
record of employee having second highest salary. Find Third highest salary... to find out third highest salary so you can write different logical query to get third highest salary.ADS_TO_REPLACE_1 Employee Table :  - Example
fetch record from oracle database using jsp-servlet?
fetch record from oracle database using jsp-servlet?  how can i fetch data from oracle database by using jsp-servlet. i'm using eclipse, tomcat server and oracle database and creating jsp pages and also using servlet
retrieve record from table and show it in HTML
retrieve record from table and show it in HTML  Hi. I have a field...,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values
HTML & MYSQL - retrieve record from table
HTML & MYSQL - retrieve record from table  Hi. I have a field...,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values as single
MYSQL retrieve record from Data table
MYSQL retrieve record from Data table  Hi. I have a field in database...,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values as single
Fetch user records from a table in database
Fetch user records from a table in database  Hi. I have a field...,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values
MySql Databse query to fetch results from database and display it in HTML File
MySql Databse query to fetch results from database and display it in HTML...(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma
JSP Delete Record From Table Using MySQL
JSP Delete Record From Table Using MySQL This tutorial explains you that how to write a JSP for deleting a record from database table. In this section you will see all the steps required for deleting a record of a table
Mysql Minimum Query
record from table. Understand with ExampleADS_TO_REPLACE_1 The Tutorial makes you....    ADS_TO_REPLACE_2     Query to Create Table named...) Query to view data of  Table named employee1:ADS
Mysql Minimum Query
the minimum value record from table. Understand with ExampleADS_TO_REPLACE_1...; ); Query to insert data into Table named employee1: Once your...) Query to view data of  Table named employee1:ADS_TO_REPLACE_4
How to add a column with checkboxes for each record in my table in JSP
How to add a column with checkboxes for each record in my table in JSP   Hi, Could you please explain it to me how I can add a column with check boxes for each record in my table in JSP? Also, I want to figure out a way
Mysql Last Record
) Query to view last record of  Table named employee1... Query to Create Table named employee1: mysql>... -> ); Query to insert records or rows in Table named employee1
How to solve concurrency issue when an application is running on two machine to fetch record from one database
to fetch record from one database  I have developed an application in java to run on two machines. Program will fetch a record from database and process... are not fetching/processing same record at the same time. for example: if one machine fetches
How To Insert A New Record to MS Access table database in GUI
How To Insert A New Record to MS Access table database in GUI  Hello, I've been working on the actionPerformed part of my java application that involves inserting a record into a 6-column table in my MS Access database table. I'm
Write a query to find the total number of rows in a table
Write a query to find the total number of rows in a table  Write a query to find the total number of rows in a table?   Hi, Here... following query, Select count(*) from table_name; thanks
Mysql Last Record
sec) Query to view last record of  Table named employee1...; Mysql Last Record is used to return the last records from table...; ); Query to insert data into Table named employee1:ADS_TO_REPLACE_3
PHP WHERE clause example to fetch records from Database Table
the data within the MYSQL database table. You can also fetch the results using... on the MYSQL Server and will fetch the results from the database table employee...You can query a MYSQL database based on multiple conditions. PHP & MYSQL
JDBC Select Record Example
JDBC Select Record Example  In this tutorial we will learn how select specific  record from table use mysql JDBC driver. This  select...; use the  another condition  i.e user_name="User1" then fetch
Query Question
Query Question  How would I write a query to display the name, department of the employee that earns the highest salary in the Employees table
Hibernate Delete Query
In this section we will discuss how to delete record of table using HQL
how to fetch data from mysql database table and draw a bar chart on that data using in jsp
how to fetch data from mysql database table and draw a bar chart on that data using in jsp  how to create bar chart fetch data from mysql database using in jsp.please give me a right code. yhanks in advance
Query to insert values in the empty fields in the last row of a table in Mysql database?
Query to insert values in the empty fields in the last row of a table in Mysql database?  I have some fields filled and some fields empty in the last... row. So what will be the query
mysql_fetch_object and mysql_fetch_array.
mysql_fetch_object and mysql_fetch_array.  What is the difference between mysqlfetchobject and mysqlfetcharray?   Hi friends, MySQL fetch object will collect first single matching record where mysqlfetcharray
Query on Java Swing - Table Cell Issue - Swing AWT
Query on Java Swing - Table Cell Issue  Hi, I have a query on Java Swing. we are using swing in our application, In one of the frame we... the key board focus is moving from one cell to another table cell but I am
Edit the record.
Edit the record.  sir, I have a table consist of huge data.I have... to previous edited row or edit the previous record of the previously edited... or some email.according to the sorted page we should fetch the data and edit
MySQL PHP Query delete
( ) delete query from a database table. MySQL PHP Query is used to delete the records... a table 'MyTable' that has the required fieldnames and datatypes respectively. Query... into MyTable values(07,'Q','26000'); Query OK, 1 row affected (0.01 sec
MySQL PHP Query delete
( ) delete query from a database table. MySQL PHP Query is used to delete the records... example on 'MySQL PHP Query delete'. To understand the example we create a table... (0.13 sec) Query for inserting data in table:ADS_TO_REPLACE_2 To add
Insert record into a table using DBCP
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
query regarding exporting table from jsp page to pdf
query regarding exporting table from jsp page to pdf  hello i am displaying one table on my jsp page and i want to save that table in pdf file can u...; <table border="1"> <tr><td>Name</td><
Query for gathering info from 3 tables with condition depended on 4th table
Query for gathering info from 3 tables with condition depended on 4th table  I have 4 tables, 1 User profile (PK usrid), 2 Friend list(pk ugid), 3... a query in which I will get a data of people, there updates, and comments on updates
Create table and insert data by sql query
Create table and insert data by sql query... to connect java application and execute sql query like create table in mysql database, insert some values and retrieve values from the table. Before running

Ads