Question

Student details based on Location and Date of Birth
Write a query to display student's Id and First Name whose from Coimbatore or Chennai and born on 8th Oct 1997. Sort the result set by student's Id.

Answer 1

make it brainliast

Explanation:

select from <table name> where location is Coimbatore and Chennai,where date of birth is 08/10/1997;

primary key should must me set to student id

you have to provide the table name

you have to provide the table

you have to provide the coloum number atleast

syntax: select from<table name> where <coloum name>is <desired value>,where<coloum name>is <desired value>;

hope you would understand please like and 5 star

thank you have a nice day

Answer 2

Answer:- You need to write a student query according to the location and date of birth provided. For that first you need to do is,

First you need to select from <table name> where the location is given as Coimbatore and Chennai, and where date of birth is also provided as 08/10/1997.

Then you need to set the primary key.

The primary key should be set to student id.

After that you need to provide the table name and then you also need to provide the table.

After providing with these details and table you now need to provide the column number.

This is your syntax for a query of a student with the provided location and date of birth

syntax: select from<table name> where <column name>is <desired value>, where<column name>is <desired value>;

A query works by adding meaning to the code required for some specific purpose.

Choosing the database and the language of query is very important when you work with the query.

A software that counts, sums and retrieves selected records from a database, may be a part of a large application and be limited to a specific type of retrieval.

Such as pulling up a customer account on screen, or it can refer to a general-purpose query language that allows any condition to be searched and selected in the program.

To know more about the given topic please go through the following

Link1:- https://brainly.in/question/18407271?

Link2:- https://brainly.in/question/16439859?

#SPJ3