write sql program to get the detail of student in a class?
Answer Posted / bhagwat sharma
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 ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is deploy, process and build? : sql server analysis services, ssas
How can change procedure in sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
What are the differences between having and where clause.
How can sql server instances be hidden?
Does any body please help me what question's have asked for SSRS in the interview?
To which devices can a backup be created and where should these devices be located? : sql server management studio
whats the maximum size of view state??
What is scrollable cursor?
What do you understand by a view?
Explain index in sql server?
Why should one not prefix user stored procedures with ‘sp_’?
What is lock escalation? : sql server database administration
How to run sql server 2005 books online on your local system?
Define Wed Edition in SQL Azure?