Answer Posted / raveendran

SQL>select * from a;

A B
---- -------------------------
1 Name
ABC
BCA
fdhgjdshfj

3 Name
ABC
BCA
fdhgjdshfj

2 Name
ABC
BCA
fdhgjdshfj

4 Name
ABC
BCA
fdhgjdshfj

5 asd

A B
---- -------------------------
asd
asd
asdd

6 asd
asd

7 asd asd
8 asd asd

sql>select count(b),b from a group by b having count(b)>=1;

T(B) B
---- -------------------------
4 Name
ABC
BCA
fdhgjdshfj

1 asd
asd

1 asd
asd
asd
asdd

2 asd asd

What is a sql select statement?

1030

---

What is sql entity?

1087

---

how to use 'mysql' to run sql statements? : Sql dba

1043

---

What schema means?

883

---

How much does a sql dba make? : SQL DBA

935

---

i have some prob lem to tell me about my self in interview first round ...

2158

---

How many tables can a sql database have?

970

---

Why are indexes and views important to an organization?

945

---

What are inbuilt functions in sql?

1043

---

What is record in pl sql?

1073

---

Can I call a procedure inside a function?

999

---

How to look at the current sql*plus system settings?

1141

---

how can we know the number of days between two given dates using mysql? : Sql dba

1041

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1124

---

What is difference sql and mysql?

972

---