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,

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

query to fetch the highest record in a table

Questions by Category