Question about Quest Software SQL Navigator Professional Edition 3.2 (PRO-NAV-PK) for PC

1 Answer

Create the SQL that would generate a list of cities and a count of the number of vendors within each city. Order the data by city in ascending order.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

SELECT syudad.city, count(vendor.city) FROM syudad INNER JOIN vendor ON syudad.City = vendor.city group by syudad.city;

Posted on Dec 16, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Construct both an ungrouped and a grouped frequency distribution for the data given below: 139 130 128 134 140 139 136 130 136 128 138 137 134 128 127 136 140 132 141


Sorry to disappoint you but I will just give you directions to do it yourself.
Ungrouped
First sort the data in ascending order (from lowest to highest value)
Create a two-column table
In the first column enter a data value.
In the second column enter the frequency of a data item
Count how many times one particular data value appears in the set (how many repetitions). If it appears only once, its frequency is 1; twice, frequency 2, etc.
For each single (different) data value complete the frequency column.

Grouped
For grouped data representations you create classes: A class is just an interval of values, for example between [125, 130[
For each class interval you create, count how many data values fall within the interval. For the class given as example it will encompass all values between 125 and 129, It I counted correctly its frequency is 4.
Complete the frequency table for the class.

How many classes should you create? Usually this information is given to you. If not, create a moderate number of classes (4,5) It depends on the span of the distribution (highest value- lowest value). The intervals should have equal length. Read your instructions.

Sep 02, 2012 | Office Equipment & Supplies

1 Answer

How do i convert my numbers in ascending order?


How do you sort the data in ascending order? I scanned the guidebook several times and could not find any reference to sorting the data in any order. It looks like you have to enter the data in lists, already sorted by you. Sorry

Jun 28, 2012 | Texas Instruments TI-36X Pro Scientific...

1 Answer

Trying to type in an address on my 1st gps.


Hello,

The manual can be downloaded from Garmin.
www.garmin.com/manuals/3130_OwnersManual.pdf

1. Touch Where To? > Address.
2. Change the state, the country, or the province, if necessary.
3. Touch Search All. If you know the city, touch Spell City, enter the city/postal code, and touch Done. Select the city/postal code in the list. (Not all map data provides postal code searching.)
4. Enter the number of the address, and touch Done.
5. Enter the street name, and touch Done.
6. Select the correct street in the list, if necessary.
7. Touch the address, if necessary.

Dec 14, 2011 | Garmin Nuvi 1350LMT

1 Answer

PHP/SQL Problem


have you read the dataset in (i.e $row)?
you would require some sort of select statement to read the data frm sql into a dataset before yopu can read and display each record in the dataset.

i gather you may be new to sql statements. the bottom commect $query.... is reading the dataset into $query, the one you have issues with needs code that reads a record into $row

Jan 25, 2010 | The PHP Group PHP

1 Answer

How to sort the number data in order in L1 for ex L1 -> L1 3 2 2 3 7 4 4 5 5 7 like that thanks


There are two functions available for sorting lists. Access them via [2nd] [List] "OPS".

SortA(list) sorts the list into ascending order.
SortD(list) sorts the list into descending order.

Jan 21, 2010 | Texas Instruments TI-84 Plus Calculator

1 Answer

How do u create a profile it keeps on sayin tht i havent chose a city and my zip code is wrong pls help!!!!


Every city has its own zip code and postal code. Now in order to create a profile that has a correct city name and zip code, first you must have a list of correct zip code in every city in the world or in you place.  In that way if you input correct zip code that corresponds the correct city name then ath's the time it will stop the pop up stating wrong zip or city name.  you can refer to this site for more infor bout the zip code in the world http://embassyworld.com/data/Zip_Codes.html


Thanks

Jun 16, 2009 | Compaq ATM ModPHY DS3/T3 (DAGGT-AA)...

1 Answer

Directions without specific address


From the Main Menu, tap the Enter Address icon.
2. Select the method to enter the city: Enter City, Enter Zip Code, or Previous City.
Enter City:
Use the keypad to enter the first few
characters of the city name. Tap OK to
display the list of cities found.
The button in the lower right corner is used
to select the sorting order of the list, by zip
code or alphabetically.
Tap on the desired city in the list.
This is the way I do it. Then I get the # of miles to the city.
Good luck & have fun.

Feb 07, 2009 | Magellan RoadMate 1430 GPS Receiver

1 Answer

Export data in excel sheet and in specific column


I did not write this but look towards the end of the code and it will give you an idea on how to do it

Sub ExportToExcel(strOutputFile As String, Optional boolSuppressMessages As Boolean = False)

Dim strTemplateFile As String
Dim fso As Scripting.FileSystemObject
Dim cnn As ADODB.Connection
Dim rstTarget As ADODB.Recordset
Dim rstCustomers As ADODB.Recordset
Dim rstServiceReps As ADODB.Recordset

On Error GoTo ErrorHandler: On Error GoTo 0

Set fso = New Scripting.FileSystemObject

' Get template file path
strTemplateFile = CurrentProject.path & "\CompaniesEmployeesList.xlt"

' Copy template to the target
fso.CopyFile strTemplateFile, strOutputFile, False

' Open a connection to the workbook
Set cnn = New ADODB.Connection
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.ConnectionString = "Data Source=" & strOutputFile & ";" & _
"Extended Properties=""Excel 8.0"""
cnn.Mode = adModeReadWrite
cnn.Open

' Open the target recordset (the Excel sheet)
Set rstTarget = New ADODB.Recordset
rstTarget.Open "SELECT [ID], [Name], [City] " & _
"FROM [Sheet1$]", cnn, adOpenDynamic, adLockOptimistic

' Open Customer data recodset
Set rstCustomers = New ADODB.Recordset
rstCustomers.Open "SELECT CompanyID, CompanyName, City " & _
"FROM Customers " & _
"WHERE City = 'Madrid' " & _
"ORDER BY CompanyName", CurrentProject.Connection

' Open Service Rep data recodset
Set rstServiceReps = New ADODB.Recordset
rstServiceReps.Open "SELECT EmployeeID, [LastName] & "", "" & [FirstName] AS Name, City " & _
"FROM Employees " & _
"WHERE City = 'Madrid' " & _
"ORDER BY [LastName]", CurrentProject.Connection

' Loop through Customers result set and copy to target
Do While Not rstCustomers.EOF
rstTarget.AddNew
rstTarget![ID] = rstCustomers!CompanyID
rstTarget![Name] = rstCustomers!CompanyName
rstTarget![City] = rstCustomers!City
rstCustomers.MoveNext
Loop

' Insert blank line between result sets.
rstTarget.AddNew
rstTarget![ID] = ""
rstTarget![Name] = ""
rstTarget![City] = ""
rstTarget.Update

' Loop through Service Reps result set and copy to target
Do While Not rstServiceReps.EOF
rstTarget.AddNew
rstTarget![ID] = rstServiceReps!EmployeeID
rstTarget![Name] = rstServiceReps!Name
rstTarget![City] = rstServiceReps!City
rstTarget.Update
rstServiceReps.MoveNext
Loop

rstTarget.Close
rstCustomers.Close
rstServiceReps.Close

cnn.Close

If Not boolSuppressMessages Then
MsgBox "Workbook Created", vbInformation + vbOKOnly, "ExcelExport"
End If

ExitHere:
On Error Resume Next
Set rstTarget = Nothing
Set cnn = Nothing
Set rstCustomers = Nothing
Set rstServiceReps = Nothing
Exit Sub

ErrorHandler:
Eval "MsgBox(""Error " & Err.Number & "@" & Err.Description & "@"")"

On Error Resume Next

If Not cnn Is Nothing Then
cnn.Close
End If

Resume ExitHere

End Sub

Jan 03, 2008 | Computers & Internet

Not finding what you are looking for?
Quest Software SQL Navigator Professional Edition 3.2 (PRO-NAV-PK) for PC Logo

Related Topics:

329 people viewed this question

Ask a Question

Usually answered in minutes!

Top Quest Software Computers & Internet Experts

The Knight
The Knight

Level 3 Expert

74136 Answers

John Brooks
John Brooks

Level 3 Expert

233 Answers

marilynhudson
marilynhudson

Level 2 Expert

61 Answers

Are you a Quest Software Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...