Hi
I need to enter an select case statement into excel so that the value of a field is generated based on the option selected in a drop down. I cannot use nested IF statements as there are more than 7 options. I would like to know how to use the select case statement to get [...]
can u slove my problem..any SQL user can slove it
hey if i have ten records in my salary coloumn and i want to know the salary of the 5th greatest one.but use the subquery command take lot of time (select from max(sal) from emp where sal<(select from max(sal) from emp) writng this 5 times [...]
sorry guys. i only joined yesterday and this is my thrid question. anyways, i heard that some women hardly ever get inner orgasms while some of us get them easily. is that true? does heredity have anything to do with it?
All women are different and stimulation comes in many forms. The "inner" (vaginal) orgasm is [...]
solution + Prove that from any set of ten distinct two-digit numbers (in the decimal system), it is possible to select two disjoint, non-empty subsets whose members have the same sum
If false, then all disjoint sums are distinct. So how many are there? Essentially, pick some terms and then pick some terms from what’s [...]
When has the existence of authority lead to the oppression of a less privileged group by a more privileged group???
Oh, good lord – this is the way this idiotically, unjust, and brutal world functions!!
Read up on the recent histories of Russia, China, Iran, Iraq, Israel, Germany, South Africa, Spain, Argentina, Chile, Brazil, France, England, or [...]
Hello and thank you for looking..
I am using Excel to accumulate special requests for my customers when they come in my store. I collect the date, item requested, company, customer name and telephone number onto the spreadsheet.
Is there a way to create or use a form (program) that can ask my clerk these simply questions [...]
My yahoo group members are having a hard time accessing the edit feature on a database table. I’ve set the group settings to allow the members to do it but the database itself is not working properly. How do I go about fixing this?
there’s also setting with in creating a data base that [...]
I am trying to make a simple query, I have two fields in a table that have yes or no answers. I need to get the query to show all the info with no as the data. I typed like*no* in both criteria boxes and it is only showing me the boxes when both fields [...]
i have all the plugs in the right spot but the ps3 or the tv cant seem to find the hdmi. Any help?
if it switches back to normal then your fine all you need to do is change the Tv display to HDMI instead of Component or AV
Write a SQL statement to show the Initials, Name and TotalPay (HoursWorked * Salary/hour) grouped per employee for the first 15 days of May 2006.
Consider that the salary per hour is $12.
-totalpay is a new column that needs to be added with a ‘alter’ statement, possible subquery
Home work?
Here is a guide:
http://www.sql-ex.ru/help/
