write sql program to get the detail of student in a class?
Answer Posted / muruga nandhini.p
create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5
insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5
select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is blocking and how would you troubleshoot it? : sql server database administration
How to use group functions in the select clause in ms sql server?
Do you know what is xpath?
What is equi join with example?
what authentication modes does sql server support? : Sql server database administration
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is a trace frag? Where do we use it?
How do I start sql server agent automatically?
How can we determine what objects a user-defined function depends upon?
Where in ms sql server is ’100’ equal to ‘0’?
What are the acid properties?
Do you know data definition language, data control language and data manipulation language?
What is the purpose of indexing?
What is the most common trace flags used with sql server?
How to create a scrollable cursor with the scroll option?