i am getting multiple values in listbox

Ads
 

i am getting multiple values in listbox

hi sir, i am using msaccess 2007.my query is look like this. select distinct a.name,b.fee from table1 a,table2 b where a.stuno=b.stuno and b.recdate in(select max(recdate) from table group by stuname) order by a.name

    in a subquery multiple recdates i am getting its working fine, but in main query also i am getting multiple name but i want only distinct names

pls help me

View Answers

Ads









Related Tutorials/Questions & Answers:
i am getting multiple values in listbox
i am getting multiple values in listbox   hi sir, i am using... table group by stuname) order by a.name in a subquery multiple recdates i am getting its working fine, but in main query also i am getting multiple name
how to store multiple values from drop down in database where i am using java struts 1.3
how to store multiple values from drop down in database where i am using java struts 1.3  hii, i am coding a form where i need a keyskills attribute... is displaying.. i need code in java so that it takes multiple values
Advertisements
:( I am not getting Problem (RMI)
I am not getting Problem (RMI)  When i am excuting RMI EXAMPLE 3,2 I am getting error daying nested exception and Connect Exception  
Values to listbox
Values to listbox  I have two textboxes by the name street and city.I have an add button and a name listbox. When I enter street and city and press the add button ,all the names of the people residing there are listed in listbox
I am getting error.How can i get details
I am getting error.How can i get details  Exception in thread "main" java.sql.SQLException: Listener refused the connecti n with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect
i am getting an error in adding a menu item to a menu.
i am getting an error in adding a menu item to a menu.   i am not able to execute the menu program. i am getting an error at menu.add(menuitem); it says add method is undefined for type menu. but as far as i know that is only way
using spring rmi+maven but i am getting this exception
using spring rmi+maven but i am getting this exception  D:\Nexustool\integrationengine\trunk>mvn exec:java [INFO] Scanning for projects... [INFO] [INFO
Why the null values are stored in Database when I am sending proper values?
Why the null values are stored in Database when I am sending proper values?  I am making a project in which I am sending the image into a folder &... I am also sending the name, Rate, Dimension to the Database through the text
autocomplete(): Spring mvc with jquery: I am not getting correct value in the text filed. Please help me
autocomplete(): Spring mvc with jquery: I am not getting correct value... related birds whenever we give input in the text field. But i am getting the wrong... bird names , but whenever i selected any bird in the text filed the am getting
select tag multiple values
select tag multiple values   I want to insert multiple values in database which i have selected from select tag
I want to update the multiple values of database depending on checkbox..? Please help me out..
I want to update the multiple values of database depending on checkbox..? Please help me out..   Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes
How to pass multiple values from a servlet to JSP?
How to pass multiple values from a servlet to JSP?  hi, I want to pass multiple values form a servlet to JSP. Hw do i do that? I am able to send one value at a time without any prb, but I am unable to carry multiple (from two
multiple select values
multiple select values   can you provide an example for multiple select values for html:select tag
getting values from dropdown list
getting values from dropdown list  I am having a dropdown list which has hardcoded values ( we need it hardcoded only and will not be populated from... to the action. My action is getting called however, i am not sure how to pass
retrieve multiple attribute values
XML retrieve multiple attribute values  Hello All Am a beginner. Would like some help with this. The following is part of my XML file: <...; What I would like is to retrieve both the attribute values of process
retrieve multiple attribute values
retrieve multiple attribute values  Hello All Am a beginner. Would...; <rdfs:label></rdfs:label> </process:Output> What I would like is to retrieve both the attribute values of process:Output during execution
retrieve multiple attribute values
retrieve multiple attribute values  Hello All Am a beginner. Would...; <rdfs:label></rdfs:label> </process:Output> What I would like is to retrieve both the attribute values of process:Output during execution
How to carry multiple values from a Servlet to a JSP?
How to carry multiple values from a Servlet to a JSP?  By using the below code I am able to carry the username to a JSP (single value). ----response.sendRedirect("index.jsp?uname="+username);---- But I want multiple values
Option onclick am not getting the value ..
Option onclick am not getting the value ..    function get_val( tot_val ) { document.getElementById('TextBox1').value = tot_val; } <tr> <td><textarea id="TextBox1" name=textarea1 readonly="readonly
this is my file upload page, here i am not getting tags input field value to my servlet,please suggest a solution?
this is my file upload page, here i am not getting tags input field value to my servlet,please suggest a solution?  <html> <head> <script type="text/javascript"> var counter =1; function
Getting image pixel values
Getting image pixel values  how to get image pixels values on mouse... JPanel getLabels() { labels = new JLabel[2]; for(int i = 0; i < labels.length; i++) { labels[i] = new JLabel
ModuleNotFoundError: No module named 'will-i-am'
ModuleNotFoundError: No module named 'will-i-am'  Hi, My Python... 'will-i-am' How to remove the ModuleNotFoundError: No module named 'will-i... have to install padas library. You can install will-i-am python with following
Retriving multiple values of checkboxes in struts
Retriving multiple values of checkboxes in struts  how to retrive multiple values of checkboxes of jsp in action class   JSP Retrieve checkbox values 1)checkbox.jsp: <html> <body> <form method="post
Regarding method returns multiple values
Regarding method returns multiple values  Hi, 1)I have a requirement like,1 method returns multiple values.how to do that one. 2)can i use method, for example like getFile()[] in this way or not. plzzzzzzzzzzzzzzzzzz provide
calling a javascript function by passing multiple values from applet in web application
calling a javascript function by passing multiple values from applet in web application  Hi all, I have a requirement like this, I have to call a javascript function from JApplet by passing 3 values. I am new to Applets
Java Method Return Multiple Values
how we can return multiple values using the return statement. Example Here I... returns the multiple values. In this example I have created a class named...Java Method Return Multiple Values In this section we will learn about how
retrieve multiple columns values from multiple csv files in java
retrieve multiple columns values from multiple csv files in java  Suppose there is folder in C:\fileupload which contains these two csv files...)///// here VendorID is corresponding to file1.csv i want to retrive data from
getting dropdown values using apache commons in servlet
getting dropdown values using apache commons in servlet  i want to get dropdown values in my program in order to merge the string to my file path so...); } i tried to debug and i am getting the wright file path but while proceeding
ModuleNotFoundError: No module named 'i-am-utils'
ModuleNotFoundError: No module named 'i-am-utils'  Hi, My Python...-am-utils' How to remove the ModuleNotFoundError: No module named 'i-am... have to install padas library. You can install i-am-utils python
ModuleNotFoundError: No module named 'Sam_I_Am'
ModuleNotFoundError: No module named 'Sam_I_Am'  Hi, My Python..._I_Am' How to remove the ModuleNotFoundError: No module named 'Sam_I_Am... to install padas library. You can install Sam_I_Am python with following
ModuleNotFoundError: No module named 'i-am-malicious'
ModuleNotFoundError: No module named 'i-am-malicious'  Hi, My... named 'i-am-malicious' How to remove the ModuleNotFoundError: No module named 'i-am-malicious' error? Thanks   Hi, In your python

Ads