ZuoTi.Pro
Question

"write a query to list name, userID, password based on the given name"; Need Help

"write a query to list name, userID, password based on the given name";

Need Help

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SELECT userID, password FROM Customers
WHERE name="Given name";

In the given name text you have to provide your specific name you want to filter.

Here the Customers is your table name.

Please rate it if the above solution helps you in any way or if you have any concerns comment it, I will help you through again.

0 0
Add a comment
Know the answer?
Add Answer to:
"write a query to list name, userID, password based on the given name"; Need Help
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1. Write a query to list the first name and last name of those pilots who...

    1. Write a query to list the first name and last name of those pilots who were hired after January 1, 2010. Sort your result by the ascending order of last name. Within matching last names, order by first name. 2. Write a query to list flight number, pilot number, pilot last name for all flights whose destinations are using the IN keyword. 3. Write a query to list the names and telephone numbers of the passengers who have reservations...

  • I have no experience with SQL and I need to write commands to query the following:...

    I have no experience with SQL and I need to write commands to query the following: List all patients with the last name of “Johnson”. List all patients who are female. List all patient last names and the medical record number of each. I've watched Khanacademy videos and tried some other online tutorials but I just cannot find the information or help I need to finish this assignment. I'm in an HIM program, but that is not an option on...

  • Write an SQL query to return the users who posted the most number of jokes on...

    Write an SQL query to return the users who posted the most number of jokes on 1/1/2019. Database: create table User( userid varchar(30) not null, password varchar(30), firstname varchar(30), lastname varchar(50), email varchar(50), gender char(1), age integer, banned boolean, primary key(userid), unique(email)); create table MyFriends( userid varchar(30), friendid varchar(30), primary key(userid,friendid), foreign key(userid) references User, foreign key(friendid) references User(userid)); Create table Jokes( Jokeid integer, title varchar(100), description varchar(255), authorid varchar(30) not null, primary key(jokeid), posttime Datetime, foreign key(authorid) references User(userid));...

  • Course: Fundamentals of Databases Write a Query for the Following Table. Table Name: Student Stu_ID Name...

    Course: Fundamentals of Databases Write a Query for the Following Table. Table Name: Student Stu_ID Name Age Address Phone 1452364 Alla 22 Riyadh 7772223310 1452365 Ahamed 25 Jeddah 7772223311 a) Write a Query for Create Table: b) Write a Query for insert filed in above Given Table. c) Write a Query for Replace Age = 25 Replace by 26 the above given Table. d) Write a Query for Remove Student ID =1452364 one Row above given Table. e) Drop Student...

  • Query “Sales.Store” table to obtain the list of “Name” and “SalesPersonID” where the store name starts...

    Query “Sales.Store” table to obtain the list of “Name” and “SalesPersonID” where the store name starts with the letters “g” through “j” and the SalesPersonID is greater than 283. Make sure that the list is sorted by “SalesPersonID” and then by “Name” fields in a descending order. Be sure the query returns all the required rows.

  • Write a query in SQL to list the following information of the artists in movie industry....

    Write a query in SQL to list the following information of the artists in movie industry. Limit this information to only 5 artists. Sort the information by age descending order.          Full name : first name and last name separated by space          Age: Current age          Address: State that he resides          Contact number: Phone number This is from an artist table, where first_name, last_name, contact_no, address, birth_date are the fields in the table. Birth date in the table...

  • On Dev C++, write a C++ program that prompts the user with the following option: 1)...

    On Dev C++, write a C++ program that prompts the user with the following option: 1) to enter a student information such as First Name, Last Name, SS# formatted as ###-##-####, userID and Password and store them into a struct data type. 2) to display the student information as shown in the example below: Name: Mary Last Name: Parker SS#: 000-00-1398 userID: mParker Password: ******** 3) Exit the program.

  • (TCO 6) Write a query to list the customer first name, last name as a single...

    (TCO 6) Write a query to list the customer first name, last name as a single field with a heading of Customer along with the balance sorted by balance from lowest to highest. SalesRep Customer PK ReplD PK varchar(20) varchar(20) decimal(10,2) CustomerID int -OH Last Name FirstName Last Name varchar(20) Commission Rate FirstName varchar(20) Street varchar(20) City varchar(20) Order State char(2) Zipcode char(5) HO. ---OPK OrderID Balance decimal(10,2) ReplD int FK1 CustomeriD OrderDate ShipDate Part int int date date PK...

  • Write an sql query to list the customers last name, seating cost, seating tip and service...

    Write an sql query to list the customers last name, seating cost, seating tip and service date for all customers with last name Smith or jones or brown. SAMPLE DATA BASE (Key fields are underlined.) Employee EMP_ID EMP_FNAME EMP_LNAME EMP_STREET EMP_CITY EMP_STATE EMP_ZIP EMP_START_DATE Table TABLE D AREA ID TABLE SEATS Area AREA_ID AREA NAME AREA SUPERVISOR EMPLOYEE_ID Customer CUST ID CUST_LAST_NAME CUST_NUMBER_OF_GUESTS Assignment EMP ID TABLE ID Seating CUST_ID TABLE_ID SEATING COST SEATING DATE SEATING TIP

  • VB program How to write a code that reset your password I need password reset method...

    VB program How to write a code that reset your password I need password reset method that gets your current password and gets the new password by two Textboxes and reset button that reset the password to new one. use the Sub resetpass(....)

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT