473,395 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

need help urgently

hi to all experts,
i am working on search engine program, and i need an sql statement that i found hard to do.

table student:
student_name course_name
data:
mike algebra
mike english
sandy english
sam english
sam algebra

sql: get all students that have courses Algebra AND English in the same time.
Oct 31 '06 #1
1 1331
NeoPa
32,556 Expert Mod 16PB
This is more complicated than it sounds at first glance.
Try this though
Expand|Select|Wrap|Line Numbers
  1. SELECT [Student_Name]
  2. FROM [Student]
  3. WHERE UCase([Course_Name]) In('ENGLISH','ALGEBRA')
  4. GROUP BY [Student_Name]
  5. HAVING (Min([Course_Name])<>Max([Course_Name]))
  6. ORDER BY [Student_Name]
Oct 31 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Zeeshan | last post by:
Hi Everybody, I want to search the filename recursively for "this is the code original" using linux command grep or ls or any other Result should be as follows: FilenamePath and Linenumber in...
0
by: Kamliesh Nadar | last post by:
Hi I am developing a software using VB.NET I am facing following problems - 1. Though I have placed the NotifyIcon control on the window service application, after starting the service I am...
1
by: Dhiraj | last post by:
hello, everybody, this is Dhiraj here. I need help urgently, as i am getting error on my web page. The error is "Microsoft JET Database Engine error '80004005'" whenever i want to open links of...
1
by: net4matrimonials | last post by:
I m using session veriables of asp.net on two websites www.net4professionals.com(job site) and www.net4matrimonials.com (bride/groom service) when i create a session on page A i use codeing...
0
by: Asim Khan | last post by:
Dear all, A well reputable group of companies in Pakistan we urgently required a System Support Engineer for our sister concern factory located in Karachi at Korangi Industrial Area, Preference...
1
by: surrayya | last post by:
AOA: Is there any one to help me.i am in great trouble.i want to read a file in c++ program that is consisting of data in 2cols and 70 rows. Tokens freq abcd 50 dssd ...
4
by: Flamingo | last post by:
Hi folks, I want a webpage, there would be a input textfield, and a "sumbit" button there, if you press the submit button, the contents you input to the textfield would be send to your...
0
by: efix | last post by:
hey there i need help urgently.. neone hu cud help me?? U c i m tryin t figure out how to program a vb .exe to login into a internet account inreal time. i m playin an online game....
2
by: rkarthik | last post by:
Hello vectors, I am a beginner in vb.net programming and a student. As my final year project I wish to develop a compression tool.Is there any way to impleiment Huffman's compression algorithm in...
16
by: techystud | last post by:
Hi, I am doing a Left Join between two views wherein the column used in the ON condition has empty string rows in the first view. while running the query the application flashes, shows #ERROR...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.