Write a query to display a row using index

Ads

 
 

Share on Google+Share on Google+

hemant kumar
Write a query to display a row using index
1 Answer(s)      6 years and 11 months ago
Posted in : SQL

Write a query to display a row using index

Ads
View Answers

November 19, 2010 at 5:36 PM


Hi,

The indexed column of the table needs to be set as a parameter in the where clause.

The query string is as follows-

select * from employee where empid='35';

Thanks


Ads









Related Tutorials/Questions & Answers:
Write a query to display a row using index
Write a query to display a row using index  Write a query to display a row using index
to write an SQL query using insert statement
to write an SQL query using insert statement  I need to write an sql query for the below using InSERT command.pls help. Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL
Advertisements
Write an applet to display scrolling image in an applet window using thread.
Write an applet to display scrolling image in an applet window using thread.  Write an applet to display scrolling image in an applet window using thread
write a java pogram to add elements to linked list using keyboard and display it
write a java pogram to add elements to linked list using keyboard and display it  write a java pogram to add elements to linked list using keyboard and display
Write a java program to display the season given the month using switch case
Write a java program to display the season given the month using switch case  Write a java program to display the season given the month using switch case
delete row using id
delete row using id  package pkg2; import org.hibernate.Query; import...()); } } } this is the code m using . Error is -query must begin with SELECT or FROM... = "delete from Insurance insurance where id = 2"; Query query = sess.createQuery
select Query result display problem
select Query result display problem  Hi, String SQL_QUERY ="from Cc"; Query query = session.createQuery(SQL_QUERY); for(Iterator it=query.iterate();it.hasNext();){ Object[] row = (Object[]) it.next
display sql query in hibernate
display sql query in hibernate  If you want to see the Hibernate generated SQL statements on console, what should we do
Want to display Arraylist items on same row in JSF
Want to display Arraylist items on same row in JSF  I want do display values of one arraylist on same row using datatable? If i use h:column, then it goes on different row. Please tell me, how I can do it?   Hi Friend
Write a question to display the follwing
Write a question to display the follwing  Write a Java program to display a pattern?   String str = ""; int count = 4; for( int i=9,j...++; } System.out.print(str);   class Display { public void
display the hidden text from that row, when onclick on a row of 1- 10
display the hidden text from that row, when onclick on a row of 1- 10  Using JSP: I'm displaying a set of values from the databse in a table rows (1 to 10)in jsp page, when onclick on one of the view row, it has to submit
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- Insert into employee values ('35','gyan','singh'); Thanks
add row in grid using dojo
add row in grid using dojo  add row in grid using dojo
delete multiple row using checkbox
delete multiple row using checkbox  how to delete multiple row in a table which is connected to database using checkbox
delete multiple row using checkbox
delete multiple row using checkbox  how to delete multiple row in a table which is connected to database using checkbox
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 is the answer, we can find the total number of rows in a table using following query
Delete Query using HQL
Delete Query using HQL  Can we write 'AND' with 'WHERE' clause in delete query using HQL? For example: delete from table name where field1 = value1 and field2 = value2   The example query i have written
Write a byte into byte buffer at given index.
Write a byte into byte buffer at given index.  In this tutorial, we will see how to write the given byte into byte buffer at the given ... ByteBuffer putChar(int index, byte b) The putChar(..) method write
to write a program to display the employee details..
to write a program to display the employee details..  To dipslay the employee details like empid,empname,salary,wonno bye using java swings.by running this program the new window has to be opened asking us to enter all
delete row from a table using hibernate
delete row from a table using hibernate  //code in java file String hql="delete from CONTACT c where ID=6"; Query query=session.createQuery(hql); //error when executing above code CONTACT is not mapped
SQL display date in between query
SQL display date in between query  how to get ( 15 march 2011) and (15/03/2011) output using SQL
how to write a query for adding records in database
how to write a query for adding records in database  How write fire query in JSP for adding records in database
write a programm using java
write a programm using java  print the following using java programming
Write a float value into float buffer at given index.
Write a float value into float buffer at given index.  In this tutorial, we will see how to write the given float value into float buffer at the ...(..) method write the given float value into associated buffer at given index
Write a int value into int buffer at given index.
Write a int value into int buffer at given index.  In this tutorial, we will see how to write the given int value into int buffer at the given .... abstract  InttBuffer put(int index, int value) The put(..) method write
By using Applet display a circle in a rectangle
By using Applet display a circle in a rectangle  Write a java applet to display a circle in a rectangle
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- delete from employee where id='35'; Thanks
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... row of my MYSQL database. Now I want to fill up those empty fields in the last row. So what will be the query
delete multiple row using checkbox
delete multiple row using checkbox  delete multiple row using checkbox   We are providing you the code where we have specified only three fields bookid,author and title in the database. 1) Create book.jsp <%@page
Write a long value at given index into long buffer.
Write a long value at given index into long buffer.  In this tutorial, we will see how to write a long value at given index into long buffer... write the given long value into buffer at given index. abstract
Shifting Row Using JSP
Shifting row using JSP       In this program we are going to shift the row using java... up. The starting row is 5 and end row is 10 and which will be shifted up 5 rows

Ads

 
Advertisement null

Ads