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
can you implement data mining in SSRS?
What are the different ways you can create databases in sql server?
What is a primary key?
What do you mean by acid?
Difference between DELETE and TRUNCATE?
What do you mean by collation recursive stored procedure?
Write a sql query to display the current date?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a mixed extent?
What are the different types of normalization?
How to return the second 5 rows in ms sql server?
Why truncate is ddl command?
How you would rewrite the sql query to return the customerid sorted numerically?
Can you explain about buffer cash and log cache in sql server?
Mention the differences between substr and charindex in sql server.